Hi,
We have Excel files with few columns are always/sometimes blank. When we try to upload the excel, Celonis automatically identify and select the datatype for each column based on the first x records . Even though column has null values Celonis considered them as INT and then during the data model load this gets failed.
We have many columns and manually checking data type for each column is very time taking. Is there any solution to this?
Hi,
What you could try is to sort the Excel with cases which have the least number of NULL cells on top. That way Celonis will consider these for the first rows and will detect the correct data types.
I would advise to keep the inter-case sorting of activities intact, especially if the timestamp is not providing an absolute ordering of the activities.
Plan B, which is way less nice, is to add a dummy case row just for type detection, which you then statically filter out from your datamodel / analysis.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
