Join is not working?

[Thomas_5]

I am trying to join two tables in QlikSense Enterprise,  but if I do it, only the fields from the second table appear in my new table.

Here is my code:

[joinTable] :
LOAD

[unit], 
[type], 
[__KEY_usage],[__KEY_activity]

Resident E7_activity
WHERE NOT IsNull([__KEY_activity]);
left keep load [time], [data],[__KEY_activity]
Resident E7_items;

In the pictures there is a screenshot from the Data Model Viewer, the tables which belong to this issue are red circled.

Can you tell me how I should handle that, so that all fields appear in my new table ?

Regards

Thomas

[abhijitnalekar]

Hi @Thomas_5 ,

Please do aliasing to the field as below.

[joinTable] :
LOAD

[unit] as JoinTUnit, 
[type] as JoinTType, 
[__KEY_usage],[__KEY_activity]

Resident E7_activity
WHERE NOT IsNull([__KEY_activity]);

left keep

load

[time] as E7Time, [data] as E7Date,[__KEY_activity]
Resident E7_items;

[Thomas_5]

Hello Abhijit,

Thanks a lot for your answer, it is better now but still not as I would like it to be.

Somehow the fields "E7Time"  and "E7Data" created a new table instead of joining the [joinTable].

Do you know how to handle that?

Regards 

Thomas

[abhijitnalekar · Accepted solution]

Hi @Thomas_5 ,

Please remove keep from the join

[joinTable] :
LOAD

[unit] as JoinTUnit, 
[type] as JoinTType, 
[__KEY_usage],[__KEY_activity]

Resident E7_activity
WHERE NOT IsNull([__KEY_activity]);

left 

load

[time] as E7Time, [data] as E7Date,[__KEY_activity]
Resident E7_items;

[Thomas_5]

Hello @abhijitnalekar 

So I removed it, but then it looked the same.

But then I wrote "left JOIN Load" and it worked.

Thank you

Best Regards

Thomas