Add a column with current date in each scheduled import

Add a column with current date in each scheduled import

Hi Team,

We have an excel file in a FTP that is updated every hour (overwritten) from another source.
We would like to import this file into a table of our Zoho Analytics account once a month, and keep the historic data of each month (without overwritting it).
When we schedule the data import in Zoho Analytics, we can select the option "Add records at the end", so we keep the data of each import. But we don't know the date of each data import and we cannot differentiate them. So we would like to add a column in our Analytics table that stores the date of the imported data. How can we achieve this? Or is there any other workaround that solves our problem?

Many thanks!