One Star

tMerge suggestion

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.
1 ACCEPTED SOLUTION

Accepted Solutions
Employee

Re: tMerge suggestion

Merging may match two behaviour: joining or appending. Delostilos has recently created 425 and 424 that may interest you.
2 REPLIES
Employee

Re: tMerge suggestion

Merging may match two behaviour: joining or appending. Delostilos has recently created 425 and 424 that may interest you.
Four Stars

Re: tMerge suggestion

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.