How can I to do Left Join? NoConcatenate

07mishin — Thu, 09 Dec 2021 20:26:34 GMT

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.

topic How can I to do Left Join? NoConcatenate in App Development