How to Load multiple different CSV file to Azure Data Lake?

sarveshpandey23

Hi All,

I am new to Alteryx, and I am trying to upload multiple different csv to Azure Data Lake storage Gen 2. 

I am able to connect Source and ADLS.

In source side, i used Directory Tool which gets the metadata of the files but I am not able to connect that location and pick and upload those files ADLS.

Can someone help me on this issue.

danilang

Hi @sarveshpandey23 

As you stated in your post, the directory tool returns only the meta data of the files in the directory.  To input them, connect the output of the Directory to a Dynamic Input tool making sure to check the "Output File Name as Field" option.  This will load the data from the files with each each row containing the file name.  This technique will only work if the files all have the same schema.  If they don't, you'll need a macro based approach.  See this post for some macro-based solutions.

Dan