How to get updated new fields data into qlikview without editing the script manually

[#1]

Hi,

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

Thank You,

Mahesh.G

[tresesco · Accepted solution]

You can try :

Load

    *

From ...

[anandathome]

Only way I can think of is to add

‘Address’

to the list of columns in your Load script and then Reload.

You will not need to manually read the excel once again

[nizamsha]

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

[#5]

Hope tresesco is correct.

[#6]

Hi  Tresesco

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

[tresesco]

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 !