topic Re: How to Update field value if match criteria in QlikView

How to Update field value if match criteria

Thu, 06 Jun 2013 11:07:42 GMT

Hi, i try to update field value by using if statment, however after reload. the data still show unknown......

(conditions: value update only if the key between two table is the same)

Cost Center:

CostCode & '|' & Nature as CN,

CostCode,

nature

Table_temp:

NoConcatenate

load *, CostCode & '|' & Nature as CN

Resident TableA;

DROP Table TableA;

Table_final:

NoConcatenate

load *,

if(PartClass='C',

if(ControlDepartment='Unknown','AM')),

if(PartClass='E',

if(ControlDepartment='Unknown','AM'))

Resident Table_temp;

DROP Table Table_temp;

Please advice. Many thanks

Mic

Re: How to Update field value if match criteria

Anonymous — Thu, 06 Jun 2013 11:34:01 GMT

You are not calling the field anything. For instance:

Table_final:

NoConcatenate

load *,

if(PartClass='C',

if(ControlDepartment='Unknown','AM')),

if(PartClass='E',

if(ControlDepartment='Unknown','AM')) AS TheField

Resident Table_temp;

DROP Table Table_temp;

Jonathan

Re: How to Update field value if match criteria

Fri, 07 Jun 2013 02:18:41 GMT

The field i would like to update which is ControlDepartment. It is already exist at the QVW. Any advise?

Mic

Re: How to Update field value if match criteria

Sokkorn — Fri, 07 Jun 2013 03:02:28 GMT

Hi Mic,

Can you try this and let me know

If(Match(PartClass,'C','E'),If(ControlDepartment='Unknown','AM')) AS Field

Regards,

Sokkorn

Re: How to Update field value if match criteria

Fri, 07 Jun 2013 03:37:53 GMT

I try the statement and return messgae 'Fields name within the table must be unique'

in my case, i would like to update existing field base on conditions statment, {if A.table ID=B.table ID) and A,PartClass=C or E, then update the target fields }rather than create alias field,

In qlikview, is it possible to doing so? If it is SQL database, i can use update statement to solve it, however, i am confuse with the Qlikview environment.

Besides, how can i achieve value

Please advise. Thanks you very much

Mic

Re: How to Update field value if match criteria

Anonymous — Fri, 07 Jun 2013 10:51:17 GMT

If the field is already in the table then the statement would not add it back in.

Create a new field with a new name (e.g. NewControlDepartment). Then do another Left join in which you test whether you want to use the existing ControlDeparment or the NewControlDepartment fields, calling it something else (e.g. TheControlDepartment). You can then drop the other two fields.

Jonathan

Re: How to Update field value if match criteria

Mon, 10 Jun 2013 09:45:42 GMT

thank you very much and i i will have a try.

Re: How to Update field value if match criteria

Anonymous — Mon, 10 Jun 2013 10:07:52 GMT

Did it work ? Please mark solved if it did.

Jonathan