Alteryx designer Discussions

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

Adding a row with a specific value

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

Highlighted

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.

 

Highlighted

Dupe

Highlighted
Atom

Thank you!

Labels