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

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.

Designer Cloud

Sharepoint

Accepted answers

Sebastian_Chaieb2

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

Solution_SC_With_Barch.yxzp

All comments

@bulbul123 Use the dynamic input tool

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

@bulbul123 In that case use the batch macro

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

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15881

MarqueeCrew 13708

apathetichell 13703