Merge two datatable and adding a new column with the file path details

Help Activities
1

Hi Team,

I have multiple excel files in a folder. for ex File1 and File2

File1:

Column1 Column2
Abc 243
DEF 456

File2:

Column1 Column2
Abc 243
XYZ 789

My goal is to get a datatable as below, without looping using for each.

FilePath Column1 Column2
C:\File1 Abc 243
C:\File1 DEF 456
C:\File2 Abc 243
C:\File2 XYZ 789

using merge datatable able to achive below but need help to add the file path column and values as above.

Column1 Column2
Abc 243
XYZ 789
Abc 243
DEF 456

Please help.

Thanks.