Read file name for data output

[henrygeorge]

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

[jrgo]

Not sure if this is what you're asking, but there's an option in the Input options to "Output File Name as Field". 

[grazitti_sapna · Accepted solution]

Hi@henrygeorge 

I have made Workflow for your Problem. Please Check.

If it works Kindly accept it as Solution.

Thanks