Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

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

Create New column based on other columns

hash9
7 - Meteor

I need help in creating a new column for a given set of rows. For all rows where Bank and Year are same, create a new column which has to pick the value in "code" corresponding to position '2'.

Capture.PNG

 

Please help.

2 REPLIES 2
ZacharyM
Alteryx Alumni (Retired)

It takes a few steps, but you're looking to use the Multi-Row formula primarily - it will scan across rows based on logic.

 

The attached should solve your example - I expanded the data a bit to test it more thoroughly.

 

If this solves your issue, please make sure to mark this solution (or the one that solves it) as solved so that the community knows you've been helped!

 

Best,

Zak

dondapati
7 - Meteor
 
Labels