Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

Fill new column from multiple rows

tiverson
8 - Asteroid

What is the best way for me to approach this?

I am trying to create a new column titled "Position" that will fill in values from various columns.

Also, the file that I will download will have some blank lines at the top that need to be removed, how can I work around this?

 

Data:

tiverson_0-1638202643536.png

 

Desired Output:

tiverson_2-1638202958293.png

 

Thanks, Todd

 

 

 

1 REPLY 1
Matthew
11 - Bolide

if only one column will ever be populated, you could just concatenate them

otherwise youll need a formula like "if [field1] = null() then [field2] else [field1] endif"

Labels