Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

Count if match 2 fields in any order

I have FIELDA and FIELDB and I concatenate them in the script to be FIELDA_FIELDB. I then do a count to see how many occurrences we have of the matching pair of fields count(FIELDA_FIELDB). However, sometimes the same values could be listed as FIELDB_FIELDA. I want to group them together when the 2 fields are the same, regardless of which order they are in. Is there a way to do that?

2 Replies
YoussefBelloum
Champion
Champion

explain the issue with an example

sunny_talwar