Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys
I made a data connection key from date & unique Num in two tables and connected them to gain some data from one table, but some key became same, because some unique Num doesn't have any data.
How can I eraze these keys which became same key ?
As following photo, I only would like to connect green rectangles, and erase red rectangles connection.
Thank you guys
Load only the data from the tables if the Num field has a value:
TableA:
LOAD * FROM ...source_table... WHERE Len(Trim(Num))>0;
Load only the data from the tables if the Num field has a value:
TableA:
LOAD * FROM ...source_table... WHERE Len(Trim(Num))>0;