If condition to give value to a new field

[#1]

I have a table like this:

Nation	NameA	NameB
IT	abc
IT	def	def
FR	a2d	123
FR		456

I need to have this result

newname
abc
def
123
456

I try with

LOAD *,

     if("Nation" <> 'IT', NameB, NameA) as newname;   

And also  with

LOAD *,

     if("Nation" = 'IT', NameA, NameB) as newname;   

But in newname field I find only value form NameB  (case1) or form NameA (case 2).

I don't know why.

Thank you

A

[neelamsaroha157]

Check the attached file

[sunny_talwar · Accepted solution]

May be try this:

If(NOT WildMatch("Nation", '*IT*'), NameB, NameA) as newname;

[sunny_talwar]

or this:

If(KeepChar(Upper("Nation"), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ') = 'IT', NameB, NameA) as newname;

[#5]

Thank you, this was not what I need but it can be very usefull.

[#6]

Thank you very much.