Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
IN Which scenario you go for join and keep?
Hi,
Ceck this
http://community.qlik.com/thread/39177
http://community.qlik.com/thread/134760
Regards
ASHFAQ
Hi,
The main difference in this Join and Keep is when ever simple joins like
1. Join
2. Left Join
3. Right Join
4. Inner Join
5. Outer Join
This joins attempt the result is single table we get but when ever the Keep is used with JOINs, then the second table available associated connected to the table.
Ex:-
If simple join used
Table1:
LOAD * Inline
[ Key,A
1,A1
2,A2
3,A3 ];
Left Join(Table1)
Table2:
LOAD * Inline
[ Key,C
1,C1
2,C2
4,C4 ];
We get table like
And if use Keep with Keep join
Table1:
LOAD * Inline
[ Key,A
1,A1
2,A2
3,A3 ];
Left Keep(Table1)
Table2:
LOAD * Inline
[ Key,C
1,C1
2,C2
4,C4 ];
And we get
Regards
Anand
Hi Guys,
i know the diff b/n join and keep,but my question is in which situation we go for join,and in which situation we for keep?
Regards,
koti