Import multiple csv files (different data) and distribute to different workflows

Hi everyone!

I'm trying to import multiple csv files with completely different data and structure. I want to feed these imported files to different workflows depending on their names. Then, I want to then delete a few columns and rows in each files and then output an xlsx for corresponding csv.

I have a basic workflow which works for one file at once.

Can anyone help me make it accept multiple inputs and distribute files to multiple workflows just like the one above^?

Workflow

Input

Accepted answers

grazitti_sapna

Hi @harshpatel, here is a sample batch macro workflow that will help you to fetch multiple files with the different data structures, and then you can apply the transformations as required. Please refer to the screenshot below.

After this, I applied a filter on the filename and used the select tool to select the required columns.

I hope this helps!

Thanks!

HarshPatel_Workflow.yxzp

All comments

gabrielvilella

Probably the best way is to create a batch macro to do that process for all the files.

grazitti_sapna

After this, I applied a filter on the filename and used the select tool to select the required columns.

I hope this helps!

Thanks!

HarshPatel_Workflow.yxzp

Kurohits

Hi @harshpatel

I have created this workflow utlity which reads multiple files with different data schemas. It is very flexible and dynamic in terms of data structure and number of files. This will definetely help you to import multiple files having different structures.

Utility.yxzp

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335