topic Data Connection in Connectivity & Data Prep

Data Connection

wenyan1206 — Wed, 16 Jan 2019 07:16:17 GMT

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

Re: Data Connection

Gysbert_Wassenaar — Wed, 16 Jan 2019 07:32:26 GMT

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

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

Re: Data Connection

wenyan1206 — Wed, 16 Jan 2019 07:38:29 GMT

Thank you !
I could do well!