Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Cleaning Nulls and moving address lines

parria1
8 - Asteroid

I have a recordset that looks like the attached file. I need to make the nulls in the first two columns the value of whatever is in the row above. i have been able to do that with a multirow formula tool, but cannot move the city,state,zip to another column.

 

 

1 REPLY 1
apathetichell
18 - Pollux

Perhaps you want to use a second multi-row formula with a regex_match for city/state/zip layout as a condition and then use that to "move" it? If you can load some sample/test data someone can mock it up.

Labels