--------| 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
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
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