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.