[resolved] tMap : getting rows which are in a file but not in the other : how to?

Highlighted
One Star

[resolved] tMap : getting rows which are in a file but not in the other : how to?

Hi,
I'm pretty new to talend (starting today actually) and i want to put in a fileOutPut the diff between 2 FileInput : i want to keep only the persons (i have an idCode) which are in a file but not in the other file.
How can i do that?
Thx Smiley Happy

Accepted Solutions
Seventeen Stars

Re: [resolved] tMap : getting rows which are in a file but not in the other : how to?

Use the tMap. Join both inputs by the keys. Create an output mad of the fields of the main input and setup this output as "Inner Join reject" (settings of the output).
If you have in both inputs keys which does not exists in the other input, repeat the way above but replace the both inout flows (change main with lookup flow). 

View solution in original post


All Replies
Seventeen Stars

Re: [resolved] tMap : getting rows which are in a file but not in the other : how to?

Use the tMap. Join both inputs by the keys. Create an output mad of the fields of the main input and setup this output as "Inner Join reject" (settings of the output).
If you have in both inputs keys which does not exists in the other input, repeat the way above but replace the both inout flows (change main with lookup flow). 

View solution in original post

Highlighted
Moderator

Re: [resolved] tMap : getting rows which are in a file but not in the other : how to?

Hi stoulouse,

Please take a look at documents about: TalendHelpCenter:tMap and TalendHelpCenter:tMap operation.

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
One Star

Re: [resolved] tMap : getting rows which are in a file but not in the other : how to?

Use the tMap. Join both inputs by the keys. Create an output mad of the fields of the main input and setup this output as "Inner Join reject" (settings of the output).
If you have in both inputs keys which does not exists in the other input, repeat the way above but replace the both inout flows (change main with lookup flow). 

Hi and thx, but what do you mean with "output mad"? I'm working with Talend Open Studio, maybe this component is not available in this version?
Highlighted
One Star

Re: [resolved] tMap : getting rows which are in a file but not in the other : how to?

I guess he means "made", it's not a component.
Highlighted
Seventeen Stars

Re: [resolved] tMap : getting rows which are in a file but not in the other : how to?

I mean "Create an output containing the input fields"
Highlighted
One Star

Re: [resolved] tMap : getting rows which are in a file but not in the other : how to?

Great this is working, thx Smiley Happy
Highlighted
Moderator

Re: [resolved] tMap : getting rows which are in a file but not in the other : how to?

Hi stoulouse,

Could you please mark your topic as resolved?

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog