Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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