Python Script to Export Dashboards to CSV File - Change delimiter to pipe

Follow

Sisense Admin

April 09, 2019 15:52

Is it possible to change the delimiter from comma to vertical tab ( | ) in the Python script?

I have been unsuccessful to this point?  I have tried adding this line to the script...

 

JAQL_query["delimiter"] = "|"

 

Any help would be greatly appreciated

 

0

• 

  Moti Granovsky April 10, 2019 14:32

  Hi,

  When discussing issues/questions that aren't built-in features of Sisense, such as plugins and scripts, please either comment on the original post featuring the plugin/script in question or at least refer to it with a link.

  Assuming this is about this script, and you're trying to add the line to the "get_widget_csv" function, try adding the following line:

  JAQL_query["csvSeparator"] = "|"

   

  This property of JAQL is specified in the JAQL Syntax Reference together with the other properties that appear in that code block, such as "format".

  0

  Comment actions Permalink
• 

  Sisense Admin April 10, 2019 16:54

  Thank you, Moti!  Apologize for not commenting on the original post.  I did a search on 'delimiter' instead of reading the entire reference. Apologies for this as well.  This seems to work as expected and I appreciate your help!

  0

  Comment actions Permalink

Please sign in to leave a comment.