Hello, I am attempting to append a dataframe in PyCelonis to an existing table in the data pool. When attempting to use the data_pool_table.append() function it is throwing an error. "ERROR: Column "_CELONIS_CHANGE_DATE" does not exist".

Hi, in the dataframe, do not include the _Celonis_Change_Date as this will be automatically created in Celonis.

Thank you,

Rio

Hi Rio,

Thank you for your quick response. The dataframe I am appending does not include the _Celonis_Change_Date field, neither does the table I am trying to update.

I am also having a similar issue with the upsert function. Is there another function I can try within the PyCelonis library that will update the table with a dataframe?

using the pycelonis to append it already predefined the _Celonis_Change_Date as one of the field.

I think what you can do is, create the table using the PyCelonis and insert the data to the new table or you can try adding the field to the existing table.