keep function

[#1]

Confunsion in keep function.

[jyothish8807 · Accepted solution]

Hi Hammad,

This will be helpful

http://community.qlik.com/thread/39177

Regards

KC

[Anonymous]

Hey,

Check this out.

Understanding Join, Keep and Concatenate

Difference between left Keep vs left Join

BR,

Chinna

[jagan]

Hi,

TableA:

ID, Value1

1, One

2, Two

TableB:

ID, Value2

1, Test1

3, Test3

4, Test4

In Left Join: TableA & TableB resultant table

JoinTable:

ID, Value1, Value2

1, One, Test1

2, Two, Null

In Left Keep: Both tables will be separate both are not joined physically just join logic is applied

TableA:

ID, Value1

1, One

2, Two

Left Keep(TableA)

TableB:

ID, Value2

1, Test1

Hope this helps you.

Regards,

Jagan.