Zero rows retrieved after join

Six Stars

Zero rows retrieved after join

Hi, I am new to Talend and try to figure out why after my join conditions, my output file has zero rows.


I have 3 data sources and I am joining 1st data source to 2nd database source and 2nd to 3rd data source via Ids. For 2nd and 3rd datasource, I have Join model as Inner join and match model as All matches. and o/p is csv file. when I open the csv file, I see no values in it.





Sixteen Stars

Re: Zero rows retrieved after join

You have no data from your lookup data sources and you are using an inner join. That is why you have no data. Change the join to be an outer join and see what happens.


Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.