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.
SOLVED

Adding a row with a specific value

jh105109
5 - Atom

Hi all,

 

I am working on a file where I have a row with a company name, and within the company name is a company number. The company name is currently on row 1, but I want to have a row below the company name that is just the company number. Does anyone have any recommendations for the best way to do this in Alteryx? I provided visuals below:

 

Below is my input data:

input data.PNG

 

Below shows the row that I want to add:

output data.PNG

3 REPLIES 3
jdunkerley79
ACE Emeritus
ACE Emeritus

Try the attached.

 

2018-12-17_19-31-00.png

 

Uses a multi-field formula tool to get the account numbers out and then unions to original data.

 

jdunkerley79
ACE Emeritus
ACE Emeritus

Dupe

jh105109
5 - Atom

Thank you!

Labels