Updating a Changing Data Source File Name

[Anonymous]

Hi all,

I have a client's web folder where daily .csv's are uploaded. The .csv files are identical in structure - all that changes is date at the beginning of the file name, which is always YYYYMMDD. They would like to have a dashboard that updates with the new daily file automatically, which I'm struggling to do. As an example, the predicament looks like this:

- On Day 1 I need to access clientwebsite.com/20180423_Data.csv

- On Day 2 I need to access clientwebsite.com/20180424_Data.csv

- On Day 3 I need to access clientwebsite.com/20180425_Data.csv

Any ideas / thoughts on how I might do this?

TIA,

SamB

[Anonymous]

Hi @danextian,

supposed there is no report for the day, will your code pick up the latest source file? Would it possible to use advanced editor to look for a specific string that is constant in the file name, say for example *users_per_country.csv?

Thanks!

[danextian]

Hi @Anonymous ,

supposed there is no report for the day, will your code pick up the latest source file?
What is your criterion for the latest data source? (filename, date modified, date created?) 

Would it possible to use advanced editor to look for a specific string that is constant in the file name, say for example *users_per_country.csv?

It is possible. You can filter the table to rows that ends with a specific text string. 

 Table.SelectRows(PreviousStep, each Text.End([Column], "users_per_country.csv"))

M is case sensitive so if your file name is not always in the same case, you can try this:

 Table.SelectRows(PreviousStep, each Text.End(Text.Lower([Column]), "users_per_country.csv"))

[Anonymous]

Hi @danextian,

That's working perfectly now. Thank you so much for your help - it is much appreciated!

Cheers,

Sam

[danextian]

You're welcome. 

[danextian]

Your csv.document is incomplete... Delimiter=";", Columns=2, Encoding=1252..