We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Importing multiple files from sharepoint

aknayirp
5 - Atom

Hello everyone, 
I need help in segraggating files of a similar template from sharepoint. I'm currently dowmloading the details of the files from sharepoint and then using dynamic input to read the data of all the files. My concern is some of the files are of a different format which is not being read by the dynamic input. I want to add  a filter which can only pass the files which are in the prescribed format to run the workflow successfully while get the list of files which are not in the prescribed format and shareing it with business.  Need your help in solving this problem.

 

 

1 REPLY 1
caltang
17 - Castor
17 - Castor

You are reading the file via Download tool? Can you share a bit more about your use case - this is quite interesting. So you skip the SharePoint input tool entirely?

 

Re: Your question on different schemas - the batch macro does a better job than dynamic input in this case... https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309 

 

But one thing is, your Download - is it downloading a set of data as is or sheet names etc? What is the config like? I am fascinated by this new approach to SharePoint - I want to try it on my own also.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels
Top Solution Authors