left join Substitute

[#1]

Is there  is any substitute of left join for the table having more than one fields

[ashfaq_haseeb]

you can create composite key

Regards

ASHFAQ

[MayilVahanan]

Hi

Create a composite key if you have more than one common field between 2 tables.

Like

PID1 &'-'&PID2 as %Key

If the key fields is large length, then use Autonumber function for create the Key fields.

[#4]

then?

[ashfaq_haseeb]

Create the same key in both tables and join them

Regards

ASHFAQ

[#6]

it will change the out put

see the attachment ,it will give different output if i used left join and if i used company key

[ashfaq_haseeb]

Hi,

Check this

Regards

ASHFAQ

[ashfaq_haseeb]

Hi use this

T1:
LOAD ID &'-'& NAME as key,
SECTION,
NAME
 ;
LOAD * Inline [
ID,NAME, SECTION
1,anu,D
2,ankita,B
3,ekta,A
4,Shweta,C
];


left join 
T2:
load ID &'-'& NAME as key,
%
;
LOAD * Inline [
ID ,NAME,%
3,shialy,00
4,shruti,01
5,kirt,8
6,Stuti,.5
3,ekta,90
];

Regards

ASHFAQ

[#9]

That's I know but I dnt want to use left join

As use of it increase the execution time in my original Qvw file

[ashfaq_haseeb]

Then use apply map instead.

Regards

ASHFAQ