Names of variables in export are difficult for auromation and data analysis

Martin Pecha_2338
Martin Pecha_2338 Member Posts: 145 VERIFIED MEMBER
Third Anniversary 100 Comments 5 Up Votes 5 Likes
edited April 24 in Workflow Automation #1

I recently did a lot of heavy data analysis and data cleaning from pipedrive and it became extremely difficult to handle the names when using exported xlsx  in different programs. 

“Organisation - variable” is a bit unlucky as the standarsd is using variable names without spaces - i.e. “Organisation.variable” or “Organisation_variable” - I then have to manually clean the variables names every time I do some export. 

Comments

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,591 VERIFIED MEMBER
    1000 Comments 250 Likes Fourth Anniversary 25 Answers
    edited February 2022 #2

    Hey @Martin Pecha  - You can try running these files via Parabola before using them. If you're using Tableau, Tableau Prep can do these things for you. You can also export the data using Flatly.

  • Martin Pecha_2338
    Martin Pecha_2338 Member Posts: 145 VERIFIED MEMBER
    Third Anniversary 100 Comments 5 Up Votes 5 Likes
    edited July 2021 #3

    Hey @Martin Pecha  - You can try running these files via Parabola before using them. If you're using Tableau, Tableau Prep can do these things for you. You can also export the data using Flatly.

    Thanks @Amit Sarda , these are great ideas - however, it requires another 3rd party app you have to use. It is easier to rename all variables one in the code, when working with the same structure. I am also using Keboola as a ETL stack.

This discussion has been closed.