data load editor multiple if statements

[Qlikuser09]

this is the code i'm using ,

if([Field_Name] = 'name1' or 'Name2',1) as key.

however qlik is not assigning the value for my second field Name 2.

[Digvijay_Singh · Accepted solution]

It should be like this - 

if([Field_Name] = 'name1' or [Field_Name]  = 'Name2',1) as key

[MayilVahanan · Accepted solution]

Hi 

Try like below

if(Match([Field_Name], 'name1', 'Name2'),1) as Key

or

if(WildMatch([Field_Name], 'name1', 'Name2'),1) as Key

Wildmatch is incase-sensitive.