This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The highly anticipated Alteryx Community tradition is back! We hope you'll join us!
Learn MoreHello again, another noob question :)
I have a table of only two columns that looks like this:
Item | Classification |
a | 1 |
a,b | 2 |
a,b | 4 |
a,b | 4 |
a,b | 4 |
a,b | 3 |
b | 1 |
I would like to update it to something like this, with no commas:
a | 1 |
a | 2 |
b | 4 |
b | 4 |
b | 4 |
b | 3 |
b | 1 |
So far I'm using a Multi Row Formula with the following arguments:
The problem is with classification 4. It should be that a classification of 4 is always equal to the item not included in the classification of 1. So, if Classification 1 is an A item (like in the example), all the subsquent 4s should be B. Likewise, if Classification 1 is a B item, all the subsquent 4s should be A.
Does anyone have a clue on how to create such a formula? Thank you very much!
Solved! Go to Solution.
Use a Text to Columns and after you split the first column with a comma, you can "Split to Rows"
You'll get the results that you are looking for.
Cheers,
Mark