Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Create New field based on other fields

Highlighted
8 - Asteroid

Alteryx Masters!

Hey real simple I bet you, in the attached how can i create a new Field which is a summary of the three Year fields? In essence, I want a a new field Year which has the available years and not as separate columns?

 

Thanks!

Highlighted
11 - Bolide

Hi @ZoeM - could you provide an example of what you're trying to do? Are you wanting to sum all three years in a separate field?

Highlighted
8 - Asteroid

So I would like to have two fields: Model and Year.

Alteryx Partner

Hello @ZoeM,

 

this is indeed very easy. The magic tool to achieve such tasks is the Transpose-Tool which creates a row layout from column data. Check this link to learn more.

 

Keying the data by Model will produce the desired result, as you can see:

 

AlteryxGui_2020-02-03_21-17-26.pngAlteryxGui_2020-02-03_21-17-17.png

 

 

AlteryxGui_2020-02-03_21-17-49.png

 

Highlighted
8 - Asteroid

Awesome!

That is what I am looking for. 

 

Thanks a lot!

Labels