Hi I am reading a directory of excel files with specific sheet name "ABC123"
The file names of these excel files are "ABC 2023Dec30.xlsx" and "CO 02-02-2021.xlsx"
Excel 1 in Folder - ABC 2023Dec30.xlsx
No of Cars | Item No | Person |
12 | 12312 | Alex |
Excel 2 in folder - CO 30-02-2021.xlsx
No of Cars | Item No | Person |
15 | 123131 | Mer |
How do i output this data in these two files in a union (they both have same headers in the specific sheet "ABC123" starting from the 3rd row) and take the date as one of the outputs?
Desired Output :
No of Cars | Item No | Person | Date |
12 | 12312 | Alex | 30-12-2023 |
15 | 123131 | Mer | 30-02-2021 |
Solved! Go to Solution.
Not sure if this is what you're asking, but there's an option in the Input options to "Output File Name as Field".
I have made Workflow for your Problem. Please Check.
If it works Kindly accept it as Solution.
Thanks