Discussion Board for collaboration on QlikView Scripting.
i have an excel with country data and each sheet has different country, in wht way can i upload the datathanks
Go to Solution.
This script will also give you the "sheet name" as country in the load script.
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.
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,
Pleae see the attached picture in the previous comment
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));
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.
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 formatthanks
Did you try my loadscript above?Robert
Hi Robert i have tried it bt its not working its Scripting error
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