Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

16 Replies
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

Not applicable
Author

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
Author

Pleae see the attached picture in the previous comment

Not applicable
Author

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

Not applicable
Author

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
Author

Did you try my loadscript above?
Robert

Not applicable
Author

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

Not applicable
Author

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