Data360 Analyze

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

Desired: 10,1,2,3,4,5,6,7,8,9

(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.

Thank you

You can either type out all of the fields in the order you want using the Transform node or put the fields in the order you want in a Create Data node that has no data and put it to the top pin of a Cat node with your actual data on the bottom pin. This way it will take the field order from the top pin. Attached is a basic LNA (v3.2.6) on how to do this.

Attached files

Column Order .lna

HI Gerry,

I think the Transform node makes more sense (without having a bunch of empty Create and Cat nodes in the graph).

I tried to list the columns in the order I desired, but the output still appears to be in the order of the input.  (I also tried to output to a delimited file, to see if it worked there, and no luck either.)

Can you upload your LNA? Or screenshot the transform node where you are doing the ordering?