Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
mario-sarkis
Creator II
Creator II

Read Multiple Excel files and concatenate in one file

Dear all,

I have multiple excel files I should read and concatenate together:

For example :

first excel File Name is : KANARI_20190129      (YYYYMMDD)

second excel file is : KANARI_20190130

third Excel : KANARI_20190202

......

is there is a loop for this?

hope you can help

Thanks

 

 

Labels (1)
1 Solution

Accepted Solutions
anriretief
Contributor III
Contributor III

I the Excel files are all in the same folder you can just do the following

 

at the end of the table loaded just add * to the file name where the date is

load

......

from

[file path/KANARI*.xls];

 

View solution in original post

2 Replies
anriretief
Contributor III
Contributor III

I the Excel files are all in the same folder you can just do the following

 

at the end of the table loaded just add * to the file name where the date is

load

......

from

[file path/KANARI*.xls];