Why would Celonis throw errors saying there are multiple empty cells in my columns when there aren't any?

Question

Hello All,

I have a csv file (attached a screenshot of the same) which has the Case ID (column A), Activity (Column N) and the Timestamp (column O) in the correct format. There are also other columns in the file that I will be using for my analysis.

The error (screenshot attached) says that there are more than 100 empty cells within the Acitivity, Timestamp and CaseID columns but I have double-checked and can confirm that, that is not the case. Has anyone experienced this before? What could be the issue over here?

Celonis_errors csv_file This is an urgent matter so any quick responses would be much appreciated!

Thanks!

@1460045682 ,@joos.buijs , @hugo.victo11

joos.buijs · Accepted Answer

Hi @1460044896 ,First of all good idea to tag people, might get you a reply sooner ;) First thing that comes to my mind is that Excel somehow marks cells at the bottom of the table as 'existing'. I.e., your table could have 100's of empty rows at the bottom. Some ideas to fix this would be to copy the data to a new sheet or Excel file. Another option would be to create a table in Excel (INSERT --> TABLE) of the data. This will show you if this is the case, and will show you which rows to delete.Please let me know if this works!

.146001036 · Answer

Hi @1460044896 ,First of all good idea to tag people, might get you a reply sooner ;) First thing that comes to my mind is that Excel somehow marks cells at the bottom of the table as 'existing'. I.e., your table could have 100's of empty rows at the bottom. Some ideas to fix this would be to copy the data to a new sheet or Excel file. Another option would be to create a table in Excel (INSERT --> TABLE) of the data. This will show you if this is the case, and will show you which rows to delete.Please let me know if this works!You are right @joos.buijs. That's exactly what happened! Thanks a lot for your assistance.

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN