Dynamic Filter based on Values in master Excel

[VJ_88]

1. We have 50 excel files for which we are use directory tool
2. We have a master excel which segregates these 50 files data into 05 board categories
3. In future number of files can grow 
4. Need is once the files grow we update the master excel for New category and file and 
5. Post that we do should not have to modify Alteryx workflow 
6. Currently we have 05 filters but if new category is added in Master excel we would need to add new filter in Alteryx
7. We are trying to find a way out wherein step 6 may not be possible basis master excel filters are created dynaically

[binuacs]

@VJ_88 I think a batch macro would be an ideal solution for your use case.

[VJ_88]

Hi @binuacs ,

Thanks for taking out the time but still confused 2 different source one directory tool another master excel can be joined and basis one column 4 different branches split out

[binuacs]

@VJ_88 can you provide a sample input file and expected output for better understanding?