Renombrar un grupo de registros

[ClaudiaS220388]

Hello everyone,

Please your help to be able to group some records that contains a column called: Group

Which contains several records and I want to group 3 records of this column and rename them in a single example:

Original records:
ITS T
THAT C
ST
I want to rename this group as ST1

but in the same way I want the other records to be able to use them with their original names.

I thank you,
Greetings

[Anil_Babu_Samineni]

Try like

Load FieldName, If(Match(FieldName, 'Value1', 'Value2', ...), 'GroupMatched', FieldName) as FiledName1 From ..;

Or

Where Match(FieldName, 'Value1', 'Value2', ...) // this will give result when you want to load only these values