topic Create new field using if statement in QlikView

Create new field using if statement

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

Hi guys,

I have a field which has string values. I want to create a field flag if any of the values contain the word 'enter'.

[Location]

London,

singapore enter

china enter

enter Japan

India

Germany

This new field should seperate all values that do/dont have enter in them

Thanks,

Aaron

Re: Create new field using if statement

Anonymous — Thu, 20 Sep 2018 13:45:53 GMT

Hi Aaron

In your load script try if(match('enter ',' enter'),'Y','N') as Flag this way you will capture locations that have space before the word enter or after. If there is no space after the word just amend to 'enter'

Kindest regards

Brian

Re: Create new field using if statement

Anil_Babu_Samineni — Thu, 20 Sep 2018 13:53:07 GMT

How about this?

If(Index(Location,'enter'), Location) as Enter_Location

Re: Create new field using if statement

aaronnayan — Thu, 20 Sep 2018 14:27:39 GMT

Hi Thanks for your response.

Where do i use the field [location]?

Re: Create new field using if statement

vishsaggi — Thu, 20 Sep 2018 15:06:14 GMT

May be try this?

LOAD *,

Location,

IF(Wildmatch(Location, '*enter*') >0, Location) AS EnterLocation

FROM tablename;