Data consolidation

Question

I want to create a workflow that will serve as a checkpoint for 3 different files (eg, A,B and C).  Also, there are multiple countries for whom i am expecting 3 files. Currently, i'm preparing the workflow for only one territory and one file type. How do i factor these two parameters and design a workflow for all the 3 different files and multiple territories?

P.S. : The header is same for all the 3 files.

Do let me know if there is any other information needed. Thank you!

benakesh · Accepted Answer

Hi @Satyaki04 ,

Have you considered  macros ?

https://community.alteryx.com/t5/Videos/Build-Your-First-Batch-Macro/td-p/52900

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Batch-Macros-when-to-use-the-Group-By-the-Control/ta-p/21924

Convert wf to batch macro and  run batch macro  with  "country , file type"   grouping  .

The batch macro will run for  each  "country , file type" .