how to upload 2 excel files at a time

[#1]

Hi frnds,

i have 2 excel files in which it has 2 sheets each....

i want to load both of them at a tym.

in 1st excel file

1st sheet is

d sheet is

In 2nd excel seet we have

1st & 2nd sheet is

i want to load both the excel files using for loop?Plzzzzzzzzzzzzzzzzz helpppppppppppppppppppppppp

write the scripting code plssssss

[Chanty4u]

hi

u can use

$(vExcelsheets)' & ' *.xls)

hope this helps you

Thank you

Suresh

[krishna20]

Hi, Try this also

Loading from multiple Excel files and multiple sheets

[Chanty4u]

sry,

u can try this

ForEach vFile in FileList('$(vPath)'& ' *.xls)

[Anonymous]

Hi Arjun,

Try below script if you have same columns in multiple sheets of a Excel file.

// Configure sheet names to this variable

SET vSheetNames = 'Jan Sales', 'Feb Sales','Mar Sales','Apr Sales','May Sales','Jun Sales','Jul Sales';

// Loop through the sheets and load the data

for each vSheetName in $(vSheetNames)

Data:

LOAD *

     '$(vSheetName)' AS SheetName

FROM

[test.xlsx]

(ooxml, embedded labels, table is [$(vSheetName)]);

NEXT

OR

The second is no need to mention the Sheet name just remove the table is *** .

Note: This method only works for XLSX.

Data:

LOAD *

     '$(vSheetName)' AS SheetName

FROM

[test.xlsx]

(ooxml, embedded labels, header is 2 lines);

[ankitbisht01]

Hi, you can easy load both the excel and all the sheets in those excel at the same time easily with very simple code,

but i do think data modeling will get effected. here is the output as per our need. steps need to do.

1. You have to put your all excel at same folder.

2. This code i load all excel file  and all the sheets.

PFA

Regards

Ankit Bisht