Batch Macro needed for Fetching the data

[Puneet13]

Hi Team

I need help in the below requirements to create batch macro.

1. Multiple folders with multiple files but i need to select SAM files.

2. Select the tab "Test".

3. Fetching data only for 3 columns "A,B,C".

4. Need File name as ERN rename column name.

5. Data start from 2024 and need to pick every month folder and apply step 1 to 4.

Can somebody help me to provide an Alteryx flow unable with batch macro.

[Qiu]

@Puneet13 

Please provide a set of sample data including the folder structure and desired output.