Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have a field consisting of below values
Field1:
A
B
C
D
E
Here I want to group only A , B and C together and called it as 'Group1' and want to keep D as it is and the value E should not appear in the final output as shown below:-
New Field:
Group1,
D
Can you please help me achieve this?
Aatish
HI,
try below one
load *, If(Field1='A' Or Field1='B' Or Field1='C','Group1', if(Field1='D','D')) as New_Field;
load * inline
[
Field1:
A
B
C
D
E
];
Can u try using applymap by creating mapping table
HI,
try below one
load *, If(Field1='A' Or Field1='B' Or Field1='C','Group1', if(Field1='D','D')) as New_Field;
load * inline
[
Field1:
A
B
C
D
E
];
Can u try using applymap by creating mapping table
Hi Sasikant and Anat...
Both the solutions are working as expected...
Thanks
Aatish