topic Re: Replace field value, if condition in QlikView

Replace field value, if condition

Thu, 21 May 2015 08:03:06 GMT

Hi,

I have a table in which I want to replace certain field names subject to one condition. I have a table with three fields as below. I want to replace the field value in Identifier with Identifier 2 if the activity is Abnormal or Insufficient. The result table is found below in which I added the changes in bold font. Thank you in advance!

Initial table:

Identifier	Activity	Identifier 2
123	Normal	321
1234	Normal	4321
12345	Abnormal	54321
123456	Insufficient	654321

Result table:

Identifier	Activity	Identifier 2
123	Normal	321
1234	Normal	4321
54321	Abnormal	54321
654321	Insufficient	654321

Re: Replace field value, if condition

Thu, 21 May 2015 08:07:07 GMT

Untested syntax.

LOAD

if(Activity = 'Abnormal' or Activity = 'Insufficient', [Identifier 2], Identifier) as Identifier,

....

FROM.

...

Re: Replace field value, if condition

manojkulkarni — Thu, 21 May 2015 08:07:34 GMT

Load

if(Activity='Abnormal' or Activity='Insufficient', Identifier2,Identifier) AS Identifier

Activity,

Identifier2

From Table1..

Re: Replace field value, if condition

vardhancse — Thu, 21 May 2015 08:23:29 GMT

Yes, for Identifier we can make a condition instead of direct field.

if(Activity='Abnormal' or Activity ='Insufficient', Identifier2,Identifier) as Identifier,

This will check the Activity values if satisfies any one then identify2 value will be place for Identifier, if not Identifier value will be placed

Re: Replace field value, if condition

Thu, 21 May 2015 08:28:54 GMT

Thanks everyone! Such a simple answer. Cheers!

Re: Replace field value, if condition

venkat1 — Fri, 20 Sep 2019 06:32:35 GMT

How to write if want to rename with multiple field values?