Hey there!
I have been working with a field which specifies which tests a user experienced. The delimiter between each test is a comma and the delimiter between each test and version is and equal sign.
Example (4 different users)
test1=A,test2=A,test3=B,test4=B,test5=C
test2=A,test3=B,test4=B,test5=C,test1=A
test1=B,test2=A,test3=B,test4=B,test5=C
test1=A,test2=A
Currently, counting distinct or grouping by gives me a total of 4 distinct for this data set. I need the distinct total to be 3 since the first and second user experienced the same tests and corresponding versions although the strings are in different orders. My current method counts the first and second as different.
Any thoughts?
Thanks for your time!
Solved! Go to Solution.
Bob,
Do you mind including the workflow? Beginner Alteryx user!
Welcome to the Alteryx!
It is part of the message - you should see the filename (Count Distinct.yxmd) and the little download icon next to it.
Bob
Seems like you have the most recent version and I don't =(
Just open the yxmd file in notepad and change the 11.3 in the 2nd line to 10.5 (for example) and save it.
:-)
Thanks this works. the only modification is that I'm not splitting the test from the version.