Hi Brandie,

If I add a Merge Transform and Pull the Data into Destination,Data from each file Merges as one column in the output,what I need is a separate column for each file

This is my requirement. I have Several files each with One-Column and Several Rows

what I need is all the data is multiple files should go into one file with multiple columns

one column for one file.....can you suggest?