help me with group command

[sravankaripe]

--------| transaction UserName |dedup ID| table UserName ID

UserName ID
abc 100
..... 103

Abc 101

xyz 200

Xyz 201

i want to group it by userName where abc and Abc are same user

[somesoni2 · Accepted solution]

You would need to change the case of field UserName to either all upper or all lower before grouping

--------| eval UserName=upper(UserName) | transaction UserName |dedup ID| table UserName ID