Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Uploading data from different sheet

HI,

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Uploading data from different sheet

This script will also give you the "sheet name" as country in the load script.

16 Replies

Re: Uploading data from different sheet

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

Not applicable

Uploading data from different sheet

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,

Not applicable

Uploading data from different sheet

Pleae see the attached picture in the previous comment

Not applicable

Uploading data from different sheet

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

Re: Uploading data from different sheet

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

Not applicable

Re: Uploading data from different sheet

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

Not applicable

Re: Uploading data from different sheet

Did you try my loadscript above?
Robert

Not applicable

Uploading data from different sheet

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

Not applicable

Re: Uploading data from different sheet

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

Community Browser