How to add the creation date of a table

[JohannesBoehmer]

Dear colleagues, 

I´m downloading a table every day from another tool. Currently I´m adding for every day a timestamp manually. 

So for example, I download the data on 2022-04-27, I´m adding a column with that date in excel and I upload it to Qlik sense. Same for 2022-04-28, 2022-04-29, etc. 

Is it easily possible to let Qlik Sense do this in the Data Load Editor?

The SnapshotDate is currently manually added in my excel:

Reporting_Table:
LOAD
Country as "ISO-Code",
BU as Segment,
Item,
SnapshotDate,
"Bottom-Up (P06)" as "Bottum-Up",
"Bottom-Up Comments
(P06)"
FROM [lib://SMO_IT_FPM_CS_Folder/BDG_Tracking/*Reporting_table.xlsx]
(ooxml, embedded labels, table is Sheet1);

Store Reporting_Table INTO [lib://SMO_IT_FPM_CS_Folder/BDG_Tracking/Reporting_table.qvd];

Drop Table Reporting_Table;

Load * From [lib://SMO_IT_FPM_CS_Folder/BDG_Tracking/Reporting_table.qvd] (qvd);

 Can someone help me?

Thanks and best regards, 
Johannes

[HugoRomeira_PT · Accepted solution]

Hello,

You can use the function FileTime() to get the file modification date.

Reporting_Table:
LOAD
Country as "ISO-Code",
BU as Segment,
Item,
 Date(Floor(FileTime()),'YYYY-MM-DD') as FileCreationDate
"Bottom-Up (P06)" as "Bottum-Up",
"Bottom-Up Comments
(P06)"
FROM [lib://SMO_IT_FPM_CS_Folder/BDG_Tracking/*Reporting_table.xlsx]
(ooxml, embedded labels, table is Sheet1);

Store Reporting_Table INTO [lib://SMO_IT_FPM_CS_Folder/BDG_Tracking/Reporting_table.qvd];

Drop Table Reporting_Table;

Load * From [lib://SMO_IT_FPM_CS_Folder/BDG_Tracking/Reporting_table.qvd] (qvd);

Best regards

Hugo Romeira