I am trying to change the order of the columns before creating an output file. The system this needs to go into requires a set number of columns in a specific order. There are a total of 10 fields. I have 9, and need to add a new one at the start, with no data in it.
Current columns: 4,2,3,7,5,8,9,1,6
(Column 10 is new one with no data.)
I tried to do reorder in the Transform node, but the output is still in the same order as the input. I also tried the Filter node to add the blank column...but no luck there either.
Any help would be much appreciated.
Please sign in to leave a comment.