Forum Discussion
Append data from dynamic daily refreshed data
Good afternoon. I am trying to append data from a csv file that is refreshed daily. What I am trying to have is a accumulalive table that will keep all data and only add (append) the new data. ...
Hi Jpmercier00 ,
Based on your description, wants to know couple of problems:
- Since there is no date column in the source data, how could you add it? In the csv file or in powe query?
- Are there some other previous fields in the file or in another file? How could their dates field create?
In addtion, the .csv file will refresh when click the refresh button in power query, not certain what does append a .csv file represent.
Best Regards,
Yingjie Li
- Since there is no date column in the source data, how could you add it? In the csv file or in powe query?
Data is refrehed every day in a we site at 12:00, so the date is the current date, which I add as a new column.
2. Are there some other previous fields in the file or in another file? How could their dates field create?
No, there are no other files. Date can be created as a new column with the Today´s date.
Each time you refresh you will dowload the complete .csv that is on the web at that moment that corresponds to the current day data.
Thank you!