Hi @Dhilip_Kumar
Your workflow is set up to load an individual file, so rather than being set up as an analytic app, this is best suited to run as a macro which feeds in a folder location.
From what I can tell in your workflow, it looks like your workflow just reads in a file, filters down to Product Type A, and then outputs a new file called Sales Data.xlsx. The most efficient way to do this, assuming schemas of all files are the same, is to use a Directory Tool on the top layer folder and checking the box to also look for subfolders. This will pull every file in every folder under the top level folder. Then you can follow this with a Formula tool where you use the File Path from the Directory tool for all of the files and add on |||Sheet1$ so that you have the file and sheet designated. Then pass this resulting column through a Dynamic Input tool which will stack all of the data. Make sure that in the template in the Dynamic Input tool that you also choose the option to use file name as field so you have it as something you can reference. Now that you have a complete data set, you can run all of your data through a filter tool where Product Type = A. The resulting data set will be only records that meet this criteria. Now, following this filter, you can use another formula tool to dynamically create the desired file path also using the file path field that exists in your data as part of your formula. Then you can use an Output Data tool where you check the box for "Take File/Table Name From Field" down at the bottom and choose the option to Change Entire File Path and select the new column you created with the desired naming convention.
