core.noscript.text
Read multiple excel input files and filter based on some condition (ex : Company name : AAA) and appended into output excel file
@SaravanaShan This isn't a lot to go on, but using the macro below you can pull in multiple excel files to the workflow. It includes the file name in the output so you can filter the files you don't want.
https://community.alteryx.com/t5/Community-Gallery/Dynamic-XLSX-Input-Tool/ta-p/1393832
Bacon
If the Excel input file has different column names or validation criteria, what would be the best approach for implementation?
That depends on what those are. Column names won't be an issue, not sure what you are meaning with validation criteria.
Without actual examples, it's very hard to help out.
https://community.alteryx.com/t5/Community-Gallery/Import-Multiple-Excel-Workbooks-amp-Multiple-Shee...This might help you out!Use Import_MultipleWorkbook_MultipleSheets_AllwynThomas.yxmd and edit it to your liking.
