community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Reclassification based on previous cells

Highlighted

Hello again, another noob question :)

 

I have a table of only two columns that looks like this:

 

ItemClassification
a1
a,b2
a,b4
a,b4
a,b4
a,b3
b1

 

I would like to update it to something like this, with no commas:

 

a1
a2
b4
b4
b4
b3
b

1

 

So far I'm using a Multi Row Formula with the following arguments:

 

  • If Classification = 2 then [Item] is always equal to the previous one
  • If Classification = 3 then [Item] is always equal to the next one

 

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!

Alteryx Certified Partner
Alteryx Certified Partner

@JoaoFernandes

 

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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels