Hi,
I am trying to output one large concatenated file into several smaller individual files using the "Output Delimited (Multifile)" node, however I only want to output selected columns.
At the moment my concatenated data looks like this:
Header RowN, Unique IdentifierN, Unique IdentifierM
Header RowN+1, Unique IdentifierN+1, Unique IdentifierM+1
...
Header RowN+100, Unique IdentifierN+100, Unique IdentifierM+100
Data Row1, Unique IdentifierN, Unique IdentifierM
Data Row2, Unique IdentifierN, Unique IdentifierM
....
DataRow1488, Unique IdentifierN, Unique IdentifierM
Data Row1, Unique IdentifierN+1, Unique IdentifierM+1
Data Row2, Unique IdentifierN+1, Unique IdentifierM+1
....
DataRow1488, Unique IdentifierN+1, Unique IdentifierM+1
...
Data Row1, Unique IdentifierN+100, Unique IdentifierM+100
Data Row2, Unique IdentifierN+100, Unique IdentifierM+100
....
DataRow1488, Unique IdentifierN+100, Unique IdentifierM+100
In order to get the node to output the right header/data into each individual file, I have set up the "Output Delimited (Multifile)" node to output individual files based on the Unique Identifiers in Columns 2 and 3, however I don't actually want those columns data in the outputted file...
Is there any way to manipulate this node so that it only outputs selected columns, or is there another node which will remove the columns from the individual files?
Thanks,
Eddie