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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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