Different field names on the same flat file format
I have a requirement to generate output file of the same structure but based on the data that is being loaded into the target file, I should specify the column names differently. How can I do this. The write column header option is not helping as it is putting the same column name for all datasets.
Raghunathan Balasubramanian replied
To do this, hold the field names as a single row in a query transform using Row_Generation as source. Merge the dataset to this and you will get the desired output.
Also select "No" for "Write row header" so that the field name you desire forms the first row in the file.