Skip to main content

Hello dear community,

when creating my event log, question marks appear unexpectedly in the ID column. This makes it difficult to write the code. Can anyone help me what this might be due to?

https://aws1.discourse-cdn.com/business6/uploads/celonis4/original/2X/d/d714aa92b3052d9655acd5b0a9e17069b44641dc.pngThanks for any help!!

Hi Vanessa,

did you upload the table from which you select via CSV by chance?

I had the same problem and it occured because the CSV contained non printable or special characters in the column name.

In some rare cases it could also be that the source table from where you pull data from contains a bad character at the beginning of the ID column.

If you dont continuously update the data in the table, and therefore can simply change the tables structure, you can just rename the column to something without special characters:

ALTER TABLE <Table> RENAME COLUMN <BadColumnName> TO <GoodColumnName>;

Be careful though, as soon as you update the table via a data job (e.g. jdbc uplink or a cloud connector) it will likely break the extraction.

Then Id recommend creating a view where you rename the bad column name.


Hi Maximilian,
thank you so much, this is a good advice!!
----- Ursprngliche Mail -----

Reply