Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

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

1 Solution

Accepted Solutions
MVP
MVP

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

You can try :

Load

    *

From ...

6 Replies
MVP
MVP

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

You can try :

Load

    *

From ...

anandathome
Contributor

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

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
Valued Contributor

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

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

Not applicable

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

Hope tresesco is correct.

Not applicable

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

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

MVP
MVP

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

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 !

Community Browser