Joining two tables

[Anonymous]

Hi,
I am working on profiling some customer data in Talend Open Studio for Data Quality 6.1.1 on a Windows platform. I am connected to our main schema and within that schema are several tables. The "Customer Master Data" table contains generic information such as DOB, address, first name, last name, etc. I did run a basic column analysis on the DOB column and found several customers with null DOB's. A null DOB is only an issue for customers who are active within our system. To verify this, I would need to cross reference this information with the 'Active' column from another table called "Customer Enlistment." 
Does anyone have any experience with this?
Thank you!
Jennifer

[Anonymous]

Hi,

I did run a basic column analysis on the DOB column and found several customers with null DOB's. A null DOB is only an issue for customers who are active within our system. To verify this, I would need to cross reference this information with the 'Active' column from another table called "Customer Enlistment

Would you mind posting your setting screenshots into forum?
Best regards
Sabrina

[Ganshyam]

Hello,

Here you are required to do left outer join using tmap.

Regards

Ganshyam

[Ganshyam]

Hello,

Here you are required to do left outer join using tmap.

Regards

[Anonymous]

I am also in the same scenario ... my data set is from multiple tables and want to profile single table single column how can I do that

[Ganshyam]

Hello,

Please share the data sample and the exact output you expecting.

Regards

Ganshyam Patel

[Anonymous]

I have 3 tables customer,customer_email,email_status (common column across 3 tables is emailid(an int column))

below is the structure and data

To see the whole post, download it here
OriginalPost.pdf