Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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