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.