How to Get the Timestamp of the Excel upload through file upload option

Got the Answer from one of the Celonis Training Course :: MAX(_CELONIS_CHANGE_DATE) contain the timestamp of the last updated excel into the celonis.

Hi Pritam, I tried to use MAX(_CELONIS_CHANGE_DATE) in our data model but it didnt work, so do you know if this is a default table/column in Celonis for all data models? or you explicitly created this in your excel file Thanks, Amogh

Hello Amogh, It is the default value from the celonis, we dont have to create a column in our excel. The Type of the field is Timestamp SELECT MAX(_CELONIS_CHANGE_DATE) FROM Table_name(Excel Target Table Name)

Pritam: The Excel uploading is manual and transformation job has been scheduled. The extracted details has been represented in an Analysis. Need to mention the details of the date when this file has been uploaded. Hi Pritam, Thanks for prompt reply. I am using Celonis 4.5 (on premise) version and I have a data model where I upload one excel file for data input every week. I tried to use above statement but got column not found error. Is there anything I am missing out?

Sorry, We are using IBC for the Celonis Instances, and I am not quite sure of the error. You can create a service ticket with the celonis team to identify the issue and provide you with a solution to resolve the same.

I think it IBC that is making the difference. Thanks for your help