topic Grouping of values from same field in App Development

Grouping of values from same field

aatish12345 — Fri, 24 Dec 2021 13:02:11 GMT

Hello Everyone,

I have a field consisting of below values

Field1:

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,

Can you please help me achieve this?

Aatish

Re: Grouping of values from same field

sasikanth — Sat, 25 Dec 2021 04:05:12 GMT

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:

];

Re: Grouping of values from same field

anat — Sat, 25 Dec 2021 08:25:19 GMT

Can u try using applymap by creating mapping table

Re: Grouping of values from same field

aatish12345 — Tue, 28 Dec 2021 05:05:56 GMT

Hi Sasikant and Anat...

Both the solutions are working as expected...

Thanks

Aatish