How to read in multiple csv files on Sharepoint Online from Alteryx

[Georgia_H]

Hi, I want to read all the .csv files that are currently residing in Sharepoint online via Alteryx.

My objective is to be able to read those files and load into SQL Server db.

Any easy and simple way to achieve this?

Appreciate it.

[gawa · Accepted solution]

If you sync share point folder with your computer, then you can read files as if they exist at local computer. You just have to use Input Data tool, and specify their file location as usual.

https://support.microsoft.com/en-us/office/sync-sharepoint-files-and-folders-87a96948-4dd7-43e4-aca1...

If you are talking about how to read csv files in sharepoint from Alteryx Server, it might be tough task. You need to ask your company's IT persons.

[Georgia_H]

I'm using Alteryx Desktop on VDI machine.

[gawa]

I regret to say I'm not familiar with VDI. As I said, if sync is possible in VDI, it should be easiest way. If it does not work well, sorry I cannot advise more on this topic.

[danilang]

Hi @Georgia_H 

The technique shared by @gawa above should work on a VDI as well with the caveat that VDIs can be created as needed and their configuration is not necessarily persistent.  That means that you'll have to check for the mapping every time you log on to the VDI and apply the technique if the mapping isn't there.

Dan  

[Georgia_H]

Hi @danilang @gawa 

I'm able to map and sync folder from Sharepoint and when i used the Input Data tool to read the file, only 1 file can be read at 1 time. What I want to achieve is to read in multiple csv files from a folder. So, this solution does not meet my requirement. Please advise.

Thank you.

[gawa]

You can use wild card * when you specify file path like;

C:¥user¥hoge¥*.csv 

You can read in all file with extension .csv by doing this. Please check it out.

Note that if file scheme is not the same, it does not work well. In that case Batch macro should be configured.

[VojtechT]

I would recommend giving a try to our Sharepoint Files connector, which allows for working with multiple sheets and files at once (assuming they have identical structure). Designer 21.3.3 is required.