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

Martin Pecha_2338

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. 

Amit Sarda - Pipedrive Consultant - AmitSarda.xyz

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

Amit Sarda said:

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.