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

Reference cell from another container within the same workflow.

wonka1234
10 - Fireball

Hi,

 

I am trying to make a formula in my workflow but I want to use another number from another container.

 

I have this (A):

wonka1234_0-1654096497515.png

 

and I want to bring 

wonka1234_1-1654096579086.png

 

I just want to bring in the one row.. which is weird as I have many rows in (A)

 

Is this possible?

2 REPLIES 2
IraWatt
17 - Castor
17 - Castor

Hey @wonka1234,

If think you will want to use the append fields tool to add that data to each row from A so you can apply your formula on each row and use the data column as a variable.

IraWatt_0-1654096913128.png

 

You may need to select Allow all appends.

 

Any questions or issues please ask :)
HTH!
Ira

IraWatt
17 - Castor
17 - Castor

Is this value always going to be the same? If yes you could create a workflow constant and use that in your formula:

IraWatt_0-1654097034702.png

 

Labels