Renaming Columns in CSV

Comments

5 comments

  • Avatar
    Kobbi Gal

    Hi Karen,

     

    Have you considered using a Pre-build plugin to perform this operation?

     

    https://developers.sisense.com/display/API2/ElastiCube+Plugins

    0
    Comment actions Permalink
  • Avatar
    Karen Rasnick

    No.  I'm still working through the online training material.  Could Support walk me through the process of creating my first plug in for this example?

    0
    Comment actions Permalink
  • Avatar
    Kobbi Gal

    Hi Karen,

     

    What specific step are you having trouble with?

    0
    Comment actions Permalink
  • Avatar
    Karen Rasnick

    I downloaded the Python plug in to the server.  I renamed the plugin and added the Config Program, but I don't understand how to format the XML to properly rename the columns using current month minus logic.  

    0
    Comment actions Permalink
  • Avatar
    Kobbi Gal

    Hi Karen,

    You need to write a Python script to do the column name manipulation. You then specify the script path in the XML so when the build is initialized, it will first run the script, do what it needs to do and then run the import into the ElastiCube with the new column names.

     

    0
    Comment actions Permalink

Please sign in to leave a comment.