How to write condition by using mutiple columns to create one column in script

shabarish0587 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

I need help to create new column by using mutiple column conditions. Actually i have few columns like ID,

Comments, Withdrawn Description, Status and Withdrawn Reason. By using these columns i need to create new Column as Categroy. In Category columns we need to define three values i.e. Code, Lack, Reason.

I am giving conditions to create a New column Category by using below points.

1)Categorize as Code, if “Withdrawn” is not in the Comments and/or Withdrawn Description.

2)Categorize as Lack, if Null and/or N/A are in the Comments and Withdrawn Description

3) Categorize as Reason, if keyword match in the comments and/or withdrawn description does not align with Withdrawn reason

a) ID was submitted

“ID submitted in error”, ”Mistake”, ”Working Fine” or “Invalid”

b) Business Option

“business” , ”lower priority”, ”workaround”, ”accept”

c) Not reproducible

“Not repeatable”, “Efford”

Can any one help me on this how to write a condition.Thanks in Advance

Re: How to write condition by using mutiple columns to create one column in script

lazurens — Fri, 14 Jun 2019 13:34:48 GMT

To be able to help you with that it's better to provide a concrete example.

What I can say now, is that you break down the problem into several Flags in the loading script as follow

If(wildmatch([Description], "*Widthrawn*"), 'Withdrawn') As FlagWithdrawn

now using this flag in another resident load you create the other conditions, but personally I need concrete examples to be able to build the logic that generalizes over the cases you provide.

Thanks,

Mohamed

topic Re: How to write condition by using mutiple columns to create one column in script in QlikView

How to write condition by using mutiple columns to create one column in script

Re: How to write condition by using mutiple columns to create one column in script