Data Connection

[wenyan1206]

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

[Gysbert_Wassenaar · Accepted solution]

Load only the data from the tables if the Num field has a value:

TableA:
LOAD * FROM ...source_table... WHERE Len(Trim(Num))>0;

[wenyan1206]

Thank you !
I could do well!