How to Import Data from multiple files in a folder in Alteryx

[@lyl3645]

The directory/dynamic input works for importing files with 1 sheet only, or it will generate an error.

[@franzilazura7880]

Good day I did this however, my workflow got an error telling that I have a different schemas. Can you help me? Thanks

[@nitinat3590]

Did you find a solution? I am getting the same error.

[@franzilazura7880]

@@nitinat3590 yeah you need to make a batch macro

[@ahsanulhaq8066]

Hi Thanks for putting this detail . My header start on each file from row 4 so i skip first 3 rows in template folder that work fine but unfortunately now my header is not visible but it show as dataset row at row 1 . any clue for it.

[@somasundarammohan6202]

Very useful brother! thanks. Have subscribed to your channel as well. Have a question, is it possible to get the source file name added as a column after appending the data?

[@chetnamalik5585]

what if some of the csv files having different fields and we want to append it as new column...Is it possible ?

[@StartTechAcademy]

Yes, we can use joins to add a new column from any other table.