PQ - Get total from latest file in folder and store amount as that month (based on file date)

[Melimob]

Hi, in PQ I need to:
1) go to onedrive folder and look for latest file (format of file name will be: "Pipeline.DD-MMM-YY.csv"
2) check if MMM-YY is already present, if yes, do nothing, if no, get latest MMM-YY, sum column P called TOTAL in file and store that amount in a table against MMM-YY.

This is basically to get the pipeline amount recorded for the coming month and is based on when the report is run.

I have found how to get latest file etc. but not to test if I already have that data there and to avoid overriding the previous months.

All ideas welcome. thank you
Melissa

 

[pjmorris]

why bother to check. Simply run the query to check all files in the folder and recreate the table using the query to calculate the figure for each month (use the Group function). Provided no one changes the data in the file the information will remain correct.

 

[Melimob]

@Peter - so now I feel a little silly thank you!, sometimes danger of overthinking!

 

[pjmorris]

thank you - delighted to have helped.