tMerge suggestion

[Anonymous]

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.

[Anonymous · Accepted solution]

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

[Anonymous]

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.