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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
ankit7359
Creator II
Creator II

Not able to capture Inner Join Reject

Hi

I m trying a scenario for inner join but i want to capture the inner join rejects as well. Can anyone help me on this... its bit urgent.

0683p000009LzU3.png

0683p000009LzU8.png

Labels (2)
3 Replies
TRF
Champion II
Champion II

Your "InnerJoinReject" flow cannot be populated by row2 records as soon as they are not retrieved by the inner join.

You can only use row1 data to populate this flow.

This is logic, isn't it?

Anonymous
Not applicable

Hi,

As per your screenshot you haven't changed the join to Inner join at source side where the join happens.By default talend does Left Outer Join.So please change it to Inner Join and then rerun the job.You will get the desired output

 

Thanks,

Kiran

manodwhb
Champion II
Champion II

@ankit7359,as @TRF said,you can capture the rejects from the Main input table not from the lookup table. An tMap will support default as leftouter,that you  need to change to inner in join model option