Trying to edit row titles the easiest way possible

[BSmithdubz]

Hey all,

New to Alteryx, creating my first workflow right now, and I've been stuck thinking there must be simpler way to do this for the last 30 mins. I have a bunch of totals from my input data and I'm just trying to label the rows individually as their appropriate subtotal names. In the image attached, I am trying to rename the values in the RecordID column as the totals from the formulas on the left. Please let me know if I am not being clear here. Thanks!

[patrick_mcauliffe]

@BSmithdubz  add a Select tool before your Formula tool and change the field type to a VString with a size of 99.  As it is you're trying to fit those long descriptions into 6 characters, which doesn't work so it just isn't executing the formula.

[BSmithdubz]

I did this, and am receiving no error codes, but it did not fix the info in the rows. But also, I'm wondering if there's an easier way to edit the cells besides what I have set up here, it seems complicated for what I am trying to accomplish. Thanks.

[TonyA · Accepted solution]

For something like this I like to use Find Replace. It's easier to maintain and update than using multiple formulas or a chain of IF THEN ELSEIF..

I've attached a simple example.

[wwatson]

you could try something like this: