Renaming Columns in CSV

Follow

Karen Rasnick

August 23, 2019 21:02

How can we rename the column headings for a CSV after being imported?  We are importing the file with field1,field2,field3,field4 etc.  Column 2 will always be the month recent month end and column 3 will be the most recent month end -1. I need the name changed to the corresponding month so that data can be used in pivot tables, line or bar charts etc. 

 

Thank you,

 

1

• 

  Kobbi Gal August 26, 2019 07:41

  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
• 

  Karen Rasnick August 26, 2019 13:09

  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
• 

  Kobbi Gal August 26, 2019 13:16

  Hi Karen,

   

  What specific step are you having trouble with?

  0

  Comment actions Permalink
• 

  Karen Rasnick August 26, 2019 13:49

  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
• 

  Kobbi Gal August 26, 2019 13:52

  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.