Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
07mishin
Contributor II
Contributor II

How can I to do Left Join? NoConcatenate

Good evening. Please, help me.

Please don't check this post spam!

I need to do - left join data from [Data without price] to [Result_table], but no data in the result model.

My code:

[Result_table]:
    load
    key,
    "Number";
load * Inline [
key, Number
111, 20002000
];

[Data with price]:
load
    key,
    price;
load * Inline [
key, price, Number
111, 500, 20002000
112,, 70000000
];

NoConcatenate
[Data without price]:
load *
Resident [Data with price]
Where len(trim([price]))=0 and key > 0 and key <> '_';

Left join ([Result_table])
load *
Resident [Data without price];

Drop Tables [Data with price], [Data without price];

 What can I do? Thanks.

0 Replies