This content has been marked as final. Show 5 replies
I have a table like this:
I need to have this result
I try with
if("Nation" <> 'IT', NameB, NameA) as newname;
And also with
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.