We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Re-order columns before output and add a placeholder/blank column

Comments

3 comments

  • Avatar
    Gerry Mullin

    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

     

    0
    Comment actions Permalink
  • Avatar
    Ahmad Ali

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

     

     

    0
    Comment actions Permalink
  • Avatar
    Gerry Mullin

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

    0
    Comment actions Permalink

Please sign in to leave a comment.



Powered by Zendesk