In the file attached, I have three instances of each state for each company. For each state, I'd like to create a column where the first instance of each state says "Addition", the second instance says "Subtraction" and the third instance "Post-Apportioned Adjustment." There are duplicates of each state when the entity name changes. Can someone please provide some guidance?
Solved! Go to Solution.
Thanks very much. I can't open your workflow because I am running on an older version of Alteryx. Could you send me a screenshot of the multi-row formula and the cross tab tools?
no problem.
here's the multi-row:
and here's the crosstab:
The select:
And the workflow:
@bsolove Attached is the workflow that does what you asked for. Is this what you are looking for?