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.

 

2.png

 

 

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.