I have a situation where a column my have different rows of the same values, but the values are in different orders and therefore they are different buckets in cards, when they're actually the "same" thing.
And example of this is in A1:B3 of my attached image, where both rows under the BH_TAT.Antigens column have the same value. This is how these columns come into DOMO in their raw state, being pulled in from a connector from a 3rd party's reports.
What I want is for all selected antigens in the BH_TAT.Antigens column to always appear in the same order, so that when 2 or more rows in that column have the same value, they fall into the same bucket.
My thought to do this (and maybe this is not the best approach, just what came to mind) was split the columns the comma as the deliminator. This works and is shown in A6:F8.
Then, my plan was to pivot (A11:B15), then from there I would maybe take that output into a view and sort by ascending. (A18:B22)
Then I would unpivot (A25:E27) and then I would concat back into 1 column (A30: B32)
But I am struggling with the initial pivot.
"Select the column that has the column labels you want": I would think this would be "BH_TAT.Order_ID"
"Select the column(s) that identify a row": I would think this would be "Antigen 1","Antigen 2","Antigen 3"....etc. from C6:CF
But then I get confused with "New column name to create" , "which label identigies rows that belongs in a new column"