Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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, Number111, 20002000];
[Data with price]:load key, price;load * Inline [key, price, Number111, 500, 20002000112,, 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.