Batch macro

Question

I am using Alteryx work flow to combine multiple files. In a folder there are 150 subfolders and each subfolders has 3 types of tiles for multiple dates I only want to Pick file A from the sub folders for one specific date Now 4 of the files has different Name in just one column where majority file has cal name as 'Value' The 4 file her col name as Val. The dynamic input told throws warning for these 4 files and do not Combine them. I am trying to useBatch Macro here, butm unable to create a grid. Can someone advise

aatalai · Answer

@Bpoonam_30 go to interface designer select the cog wheel and select auto config by name let me know how you get on

Bpoonam_30 · Answer

I manged to perform these steps already, the problem is there 4 files which has different header name because of which they worflow skips the file when combining the data. I am not able to create a batch macro to resolve this issue

binu_acs · Answer

@Bpoonam_30 connect your directory with the main folder, which contains the sub folders, check the include subdirectories option, when you run you will have all the file names from the subfolders, now using a filter tool you can filter out the desired files using Contains([FileName],'name') function, same case for the particular date, then pass the outputs to the batch macro

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309