Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hei,
Is it possible to create a new field based on the value of other fields?
Basically i want to cross reference different fields and return some category.
if(field1 == "1" and field2=="2") Category = "C1"
else if(field3 == "test") Category = "c2"
else
Category = "C3" (all others)
Please don't hesitate to ask if i am being unclear.
Best Regards,
Lasse Rolstad
LOAD
field1,
field2,
field3,
if(field1 = 1 and field2 = 2,'C1',
if(field3='test', 'c2',
'C3')) as Category,
...
LOAD
field1,
field2,
field3,
if(field1 = 1 and field2 = 2,'C1',
if(field3='test', 'c2',
'C3')) as Category,
...
Again you come to my rescue. Thanks alot