Names of variables in export are difficult for auromation and data analysis
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 Posts: 1,228edited 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.0
Martin Pecha_2338 Posts: 175edited July 2021 #3Amit 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.0