Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Update Problem

Hello

I have a little probleme , i load  in QVW a table from a XLS file  , but , when i update some fields , in my xls file and i reload , my updat is not supported in qlikview table , someone have a idea ,

Thank u a lot

See attachement

1 Solution

Accepted Solutions
MVP
MVP

Re: Update Problem

When you update some fields, you are not creating a new ref matricule value, right?

Then these updated values are not loaded, because of your where clause:

WHERE NOT Exists([ref matricule]);

There is a nice example of incremental loading incl. updates and deletes of records, check the QV cookbook @

Downloads - Rob Wunderlich Qlikview Consulting

2 Replies
MVP
MVP

Re: Update Problem

When you update some fields, you are not creating a new ref matricule value, right?

Then these updated values are not loaded, because of your where clause:

WHERE NOT Exists([ref matricule]);

There is a nice example of incremental loading incl. updates and deletes of records, check the QV cookbook @

Downloads - Rob Wunderlich Qlikview Consulting

bbi_mba_76
Valued Contributor

Re: Update Problem

Hi,

maybe you are updating data for existing [ref matricule], usingf the

WHERE NOT Exists([ref matricule]);

you don't load the new values for the same [ref matricule]

Community Browser