Forum Discussion
Report that updates weekly
Hi ld17 ,
I would try a bit different approach than just renaming files.
If your data source is SharePoint folder, you can take advantage of some additional columns you get from Sharapoint, for example Date created or Date modified as you can see bellow:
You can filter the latest file based on Data created:
And in a last step you go with Combine in the first column:
Once you finnish combine, you will get your data and you will always get the latest one:
Just be sure you use same name of Excel sheets in all files and you should be fine.
Hi ld17 ,
I would try a bit different approach than just renaming files.
If your data source is SharePoint folder, you can take advantage of some additional columns you get from Sharapoint, for example Date created or Date modified as you can see bellow:
You can filter the latest file based on Data created:
And in a last step you go with Combine in the first column:
Once you finnish combine, you will get your data and you will always get the latest one:
Just be sure you use same name of Excel sheets in all files and you should be fine.
I think this is the root of the problem: Id17, you are trying to connect to the source file as to an Excel file (I guess using Web connector). You should use the Sharepoint connector instead and then filter/navigate to the Excel file which you use a a data source as discribed by Migasuke.
Cheers,
John
