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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-04-11 05:36 PM

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)
Labels
235 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2018-04-11 08:07 PM
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.
235 Views
0 Likes