Talend community forum / tMerge suggestion

pdeetlefs · 2007-01-10 15:51:59

How about a tMerge component to merge 2 files together, on a common key, with options to include or exclude records if matched or not.

plegall · 2007-01-10 16:16:49

Merging may match two behaviour: joining or appending. Delostilos has recently created [Bugtracker, feature 425, fixed] new component tUnite and [Bugtracker, feature 424, open] tJoin (tIntersection & tMinus/tExcept) that may interest you.

delostilos · 2007-01-14 00:52:06

Hi,

appending can be done with 2 flows to a flat file. The first one inserts and the second file is set to appand mode and appends records to the same file as the first flow. Then you have effectivly done a Union All like in SQL. If you the do an deduplicate via UniqRow then you have a union like in SQL. See my flows.

Uploaded Images

Announcement

Unanswered posts

#1 2007-01-10 15:51:59

tMerge suggestion

#2 2007-01-10 16:16:49

Re: tMerge suggestion

#3 2007-01-14 00:52:06

Re: tMerge suggestion

Board footer