Hello,I have a problem when uploading a csv file (activity table). After selecting the file only 1 column is returned when oonfiguring the data schema. However i was expecting multilple columns. Please find attached the c file and a screenshot.
Best answer by guillermo.gost12
That explains Guillermo. Do you have a suggestion how i can transform the csv file in order for make it fit for purpose in Celonis?
Depends on your background/tools. If you manage Linux, you can "clean" it with grep and regex.
With Atom you can do replaces where the matching pattern includes codes for start and end line
If you deal with python, you can read each line, and write out the same line without the first and last character (I think will be something like line[-1:-1] to code that slice )
OR maybe load it into excel, apply text to columns, then clean it with some cell function. And then save as excel and upload the excel instead the csv.
HTH
I think your CSV is malformed.
If I open it in a text editor (notepad++, atom, etc...) I see that each line starts with " and ends with " so Celonis interpretes is a single cell
HTH
That explains Guillermo. Do you have a suggestion how i can transform the csv file in order for make it fit for purpose in Celonis?
+6That explains Guillermo. Do you have a suggestion how i can transform the csv file in order for make it fit for purpose in Celonis?
Hello Omar,
Please check your .csv file. All columns do not follow the same format. I attach one example.
The date column has various formats.
That explains Guillermo. Do you have a suggestion how i can transform the csv file in order for make it fit for purpose in Celonis?
Depends on your background/tools. If you manage Linux, you can "clean" it with grep and regex.
With Atom you can do replaces where the matching pattern includes codes for start and end line
If you deal with python, you can read each line, and write out the same line without the first and last character (I think will be something like line[-1:-1] to code that slice )
OR maybe load it into excel, apply text to columns, then clean it with some cell function. And then save as excel and upload the excel instead the csv.
HTH
Hello Omar,
Please check your .csv file. All columns do not follow the same format. I attach one example.
The date column has various formats.
Surprise surpise, didnt know about this one! Thanks Maryam.
Depends on your background/tools. If you manage Linux, you can "clean" it with grep and regex.
With Atom you can do replaces where the matching pattern includes codes for start and end line
If you deal with python, you can read each line, and write out the same line without the first and last character (I think will be something like line[-1:-1] to code that slice )
OR maybe load it into excel, apply text to columns, then clean it with some cell function. And then save as excel and upload the excel instead the csv.
HTH
Great this solved the problem, i used simple Excel :-)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.