Filter data and then merge multiple excel files stored in a sharepoint
Thank you in advance for your help. I've an idea althought I dont know if it is possible.
We have a sharepoint list similar to this one in which each assigned analyst have to attach an excel document in astandarized manner in each row. Every row contains only 1 excel file and all of them have the same structure (Number of columns, names of the columns, etc).
Now I was able to Merge the files by using this helpful guide, but the problem is that I need to filter my sharepoint data BEFORE merging the files and by using this method it wont give me the option.
IE: Filter the data by "Argentina" Only and THEN merge all of the excel files.