2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
16 - Nebula
16 - Nebula

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