Need to get the latest file from the Sharepoint folder into Alteryx

[bulbul123]

Hey!

I have a SharePoint folder in which every week a new file is stored. I need to fetch that new file every week in the Alteryx and have to do some data processing in it. I am able to make a SharePoint connection and fetch the list of the files from the folder and then sort the file and get the latest file. After that i am getting how to get the data from that file. I tried download tool but not able to get the data.
Can someone pls help me in this.

[binuacs]

@bulbul123 Use the dynamic input tool 

[bulbul123]

i cant use the dynamic input tool as the file columns are not static and it can change with the upcoming new file.

[binuacs]

@bulbul123 In that case use the batch macro

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

[bulbul123]

can you pls tell me how using dynamic tool i can do this?

[Sebastian_Chaieb2 · Accepted solution]

Hi @bulbul123 

Please try to use my solution with Batch macro (inside macro you can check how Dynamic input is used to take dynamically data)

You have to extract package and in Directory Tool change the path to folder where you have your data:

 And run :)