New filed not found in excel

[dseelam]

Hello everyone,

I have 200 Excel Files named as Eg. Excelfile1, Excelfile2, Excelfile3,..........,Excelfile200

used below Script to load data in to datamodel

Load *,

From Excelfile*.xls

After doing Reload a single table is generated

but now I added a new excel file Excelfile201 with 4 extra columns but now my script is not able to find this 4 new columns

is there any work around to solve this issue ??

Thank you

Message was edited by: Dinesh Reddy Seelam

[sunny_talwar]

Try this code:

Table:

LOAD * Inline [

Excel, Sheet

test1.xlsx, Sheet1

test2.xlsx, Sheet2

test3.xlsx, Sheet3

];

For i = 1 to FieldValueCount('Excel')

  LET vExcel = FieldValue('Excel', $(i));

  LET vSheet = FieldValue('Sheet', $(i));

  LOAD *

    FROM $(vExcel)

  (ooxml, embedded labels, table is $(vSheet));;

NEXT i

[dseelam]

that is not possible the folders has 100 of excel files, i cant keep renaming them in script when ever there is a new file coming through FTP process every day