Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.

 

0683p000009Lwi6.png

 

 

Labels (2)
1 Reply
Anonymous
Not applicable
Author

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.