New column from existing column

[nmoverby]

Hi! Very new to alteryx and hoping someone can help.

I am trying to create a formula or use a tool that states something like this:

If column one contains the words "Section*" (noting it could be Section 1, Section 2, etc) bring it to a new column.

Then I would like to say in the new column:

If the row is blank pull down the input from the row above.

I can't share the data because its client work but really hope this makes sense to someone 😞 

Any help on which tools to use would be so greatly appreciated.

[JosephSerpis · Accepted solution]

Hi @nmoverby I mocked up a workflow let me know what you think?

[nmoverby]

Oh my goodness this helped so much! However, the Multi-Row Formula tool isn't working. It isn't getting rid of the Null Values. Do you have to specify anything else in the Expression?

[JosephSerpis]

Hi @nmoverby are you creating a new column or updating an existing one as in my example in the multirow tool i'm updating an existing column I created in the formula tool.

[nmoverby]

Ahh I got it! I looked back at your workflow. Thank you so so so much 🙂 

[CharlieS]

Hi @nmoverby 

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

Learn more about Accepted Solutions here.

Happy Alteryx-ing!