We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

Need to create a new column based on data in another column and replicate to others

yzanferr
7 - Meteor

Hello!

 

I have a table, like an example below, where I need to create a unique identifier based on data from 2 other columns.

 

Here is the data.

yzanferr_0-1638528243659.png

 

I need to create a new column where every time column "A"  appears "5010," it copies the data from column "B" where the "5010" is located until a new "5010" appears.

 

Below is what I need. I added colors to make it simpler.

yzanferr_1-1638528368674.png

Thank you all ahead for the support.

 Yuri

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @yzanferr you can do this with a Multi-Row tool.

 

Multi_Row_Tool_03122021.JPG

yzanferr
7 - Meteor

Thank you, @JosephSerpis. I thought that I would have to use macros.

Labels