Uploading data from different sheet

[#1]

HI,

i have an excel with country data and each sheet has different country,  in wht way can i upload the data
thanks

[its_anandrjs]

Hi,

If the column name of Country is same like Country what ever it is then when you load this sheets the Qlikview automatically connect thic Country column.

Rgds

Anand

[#3]

thanks for the reply, actually there is not specifie field for country, the country name is only present in the "Tab" Name but the rows and colums are same,

[#4]

Pleae see the attached picture in the previous comment

[#5]

Type it like this in your load script:

for each sheet in 'India', 'Srilanka','Burma'

Salesdata:
Load Customers,Sales
From Salesdata.xlsx (ooxml, embedded labels, table is $(sheet));

next;

Regards, Robert

[its_anandrjs]

Hi,

You have to load some thing like this and make a qvds of the tables and when you load the individual tables and laod with Filebasename( ) and store in with name Country in the load of three qvds

See the attached sample file to get the result

Let me know about this.

HTH

Rgds

Anand

[#7]

hi anand
i have QlikView Personal Edition so i am unable to open ur file, it will be great help if you can provide the script in some other format
thanks

[#8]

Did you try my loadscript above?
Robert

[#9]

Hi Robert
i have tried it bt its not working its Scripting error

[#10]

My script is working on my side in QV9. I'll post the script as a textfile in case this editor is corrupting the script. /Robert