Skip to main content
Question

I have been provided data in a parquet file, and the activity names are quite long and verbose. What's the best approach to editing the activity names to make them more intuitive/user friendly?

  • July 25, 2022
  • 4 replies
  • 1 view

Forum|alt.badge.img+14
I have been provided data in a parquet file, and the activity names are quite long and verbose. What's the best approach to editing the activity names to make them more intuitive/user friendly?

4 replies

Use python (pandas) yo load them into a data frame, then export the data frame as csv or excel and change them.

 

If there is too many activity names, then you probable will need to use python to iterate them and modify them. Or SQL.

 

Also, not really sure, but I think you can upload a parquet file into Celonis Data Ingestion using Data Upload. Then is just another table that you can manipulate using SQL.

 

HTH

 


Forum|alt.badge.img+14
  • Author
  • Level 2
  • July 26, 2022

Thanks Guillermo


Forum|alt.badge.img+14
  • Author
  • Level 2
  • July 26, 2022

I managed to achieve the desired result using a Transformation - Data Job


I managed to achieve the desired result using a Transformation - Data Job

👍