Skip to main content
Question

Issues with the file upload.

  • July 18, 2022
  • 1 reply
  • 40 views
R
Level 1
Forum|alt.badge.img+6

Hi - Actually I was trying to upload a flat file in file upload to analyse the data. After uploading I am facing some errors. I am attaching the screenshot of the error for the reference please let me know with the solutionScreenshot (130)

      1 reply

      G
      Level 12

      I know that one.

       

      Some of your lines has one more column than the rest.

      It can be some error in the extraction, or in the local modification when creating the civ

       

      There is other possible reason for that: you have a separator INSIDE the values of a column.

      So imagine you have a .CSV, with ";" as separator. So far so good, Celonis will tell you ok.

      But imagine that in one record, you have some textual description like "John Doe, Ph.D"

      Well, I found that Celonis, even as I told it the separator will be ";" it still will parse the "," in the textual field.

      So it will end up with one column more that the other lines:

      "John Doe, Ph.D" will become in Celonis as 2 columns: "John Doe" AND "Ph.D"

       

      HTH

      Community Code of ConductAccessibility statement