We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Help with Filling the cells with same values

hulkbrutus
5 - Atom
AB
022418
022418
022418
5214100
52141022418

 

Problem Statement : To fill up Col A with the values 521410 as the vales in Col B correspond to that values .

For example: whenever we get a value 521410 in col A it should automatically fill 22418 in Col B and vice versa.

3 REPLIES 3
Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @hulkbrutus ,

 

You can do this using a Formula Tool with following formulas :

 

For A 

 

IF [B] = 22418
THEN 521410
ELSE [A]
ENDIF

(assuming integer types for fields)

 

For B

IF [A] = 521410
THEN 22418
ELSE [B]
ENDIF

 

 Cheers,

 

Jean-Baptiste

mceleavey
17 - Castor
17 - Castor

Hi @hulkbrutus ,

 

You may need to provide some more information here. Are you saying you want the max value of Column A where there is a match to column B? In your example there are two values of A that match B.

 

Will there be other values of A that match, rather than just 0 and 521410?

 

M



Bulien

Greg_Murray
12 - Quasar

@hulkbrutus,

 

I am not sure I fully understand the requirements, but here are 2 solutions that get you the desired result.

Greg_Murray_0-1604586923705.png

 

Thanks,

Greg

Labels
Top Solution Authors