Hello All,
I have approximately 20 files in a folder, with some files having the same names and others different. Each file contains multiple tabs, but one common tab across all files is named "Data." My requirement is to open each file, navigate to the "Data" tab, and extract data where the "Product" column contains "HDW." I then need to consolidate this data into a single output file.
I've attached a sample file for reference. Could you please guide me in designing the Alteryx workflow to achieve this?
Thank you!
