Discussion Board for collaboration on QlikView Scripting.
I have small doubt in qlikview.
Let’s say I have a excel sheet with 2 fields of data ‘Name’ ‘salary’
I pulled these 2 fields into qlikview.
New I am just adding one more filed like ‘Address’ to source file.
So now how can I get this new filed in to qlikview without manually editing the script???
With reload option I am only getting the updated data in existing fields, new fileds I am unable to get.
Simply I just want to know is there any short cut to get new fields data in to qlikview from source file without editing the script manually
Go to Solution.
You can try :
Only way I can think of is to add
to the list of columns in your Load script and then Reload.
You will not need to manually read the excel once again
no need to load the excel again just add the field in the table but make sure ,field should be as it is in the excel then reload the data now ur new field will be added with the data
Hope tresesco is correct.
I already tried with 'select * from table' it works fine
but only problem is exicution time is more some times application is getting struck.
so i was jsut looking for some alternate solution
That may be because of the excel format, otherwise i don't see why it would get stuck or take more time. Can you upload your excel with sample data?
If you ask about alternate solution,,,,,,,,, i am not sure... but might be by creating an ODBC Connection to the excel file !