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

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

Fri, 28 Jun 2013 11:51:56 GMT

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

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

tresB — Fri, 28 Jun 2013 11:54:07 GMT

You can try :

Load

From ...

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

anandathome — Fri, 28 Jun 2013 11:55:32 GMT

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

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

nizamsha — Fri, 28 Jun 2013 11:59:56 GMT

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

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

Fri, 28 Jun 2013 12:00:17 GMT

Hope tresesco is correct.

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

Fri, 28 Jun 2013 12:03:25 GMT

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

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

tresB — Fri, 28 Jun 2013 12:21:44 GMT

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 !