Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
wenyan1206
Luminary Alumni
Luminary Alumni

Data Connection

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.

rapture_20190116160757.jpg

Thank you guys

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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

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


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

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

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


talk is cheap, supply exceeds demand
wenyan1206
Luminary Alumni
Luminary Alumni
Author

Thank you !
I could do well!