there will help simple update of script. Do you want to load all of excel files from your folder?
If yes, than do the following in from section (line 44)
From [lib://New LFS wider solution/*.xls]
(biff, embeded labels, table is [Sheet1])
Above will read all xls files in folder. If each has the same content and sheet in each xls has the same name than it will execute correctly. Actually as you have it from Data Manager there will be need to get rid of those table renaming stuff (rows 1-19 and row 69)
part with "...table is [there should be name of your sheet/table in xls] if you insert it via Data load editor than you will see what is "name of table" (most offten it is Sheet1).
Only one loading will be enought. You can delete the rest
Hope this help
Here is the Error Messaage:
Started loading data
The following error occurred:
Table 'SHEET 1' not found
The error occurred here:
Date(Date#([TPDTEE], 'YYYYMMDD') ) AS [TPDTEE],
Date(Date#([TPDTA], 'YYYYMMDD') ) AS [TPDTA],
Time(Time#(TPTIA, If(Len(Trim(TPTIA)) = 5, 'hmmss', 'hhmmss'))) AS [TPTIA],
Date(Date#([TPDTPP], 'YYYYMMDD') ) AS [TPDTPP],
Time(Time#(TPTIPP, If(Len(Trim(TPTIPP)) = 5, 'hmmss', 'hhmmss'))) AS [TPTIPP],
FROM [lib://New LFS wider solution/*.xls]
(biff, embedded labels, table is [SHEET 1])
Data has not been loaded. Please correct the error and try loading again.
The excel file looks like this:
So if I uderstand well, you will have only one excel file (important think is that it is .xls) you want to load with multiple sheets. For that case try something like that.