data coming wrong

[prma7799]

Hi All,

I using (Load * From C:\Users\a185_o_bi2support\Desktop\Test for txt\*.xlsx; )

in that I have 2 excel sheet but when I reload it data getting wrong

Output:

expected output:

[avinashelite · Accepted solution]

Hi Prashantbi,

I loaded the files its working fine, please find the attachment

[avinashelite]

If your facing any issue please share your app

[robert_mika]

Is the Excel the file the same that you getting your data from?

There is different name in your path

Do you have any XML mappping in this file?

[prma7799]

Hi Avinash,

This is manually done but I want to do this using for loop.

How to do this. if I have 50 excel file.

Thanks

Prashant

[avinashelite]

Hi ,

if the file structure i.e the fields are same then go with

load

.

.

from path\*.xlsx

* will load all the file from that folder.

If you want to other method try with this document.

Loading Multiple Excel Sheets Dynamically along with file name and sheet name