topic Re: data coming wrong in QlikView

data coming wrong

prma7799 — Tue, 10 Feb 2015 06:34:15 GMT

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 — Tue, 10 Feb 2015 06:40:25 GMT

Hi Prashantbi,

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

avinashelite — Tue, 10 Feb 2015 06:41:15 GMT

If your facing any issue please share your app

robert_mika — Tue, 10 Feb 2015 06:46:26 GMT

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 — Tue, 10 Feb 2015 06:53:43 GMT

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 — Tue, 10 Feb 2015 07:43:31 GMT

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.