Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to create a new field name grouping based on another felid like this:
field 1, new field
a, x
a, x
b, y
b, y
c, x
d, x
f, y
Means I want to say if filed 1 is a,b,c,d then new filed is x and if it's b,f then is y.
Thanks,
HI
Try like this
Load *,if(match(field1,'a','c','d'),'x','y') as NewField;
Load * Inline
[
field1
a
a
b
b
c
d
f
];
Hope it helps
HI
Try like this
Load *,if(match(field1,'a','c','d'),'x','y') as NewField;
Load * Inline
[
field1
a
a
b
b
c
d
f
];
Hope it helps