Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

How do I access the value in a column in a dataste and use it on another dataset

TimBlaze
5 - Atom

Hi Everyone, 

 

I am quite new to Alteryx. I have a process in Alteryx designer which produces two different outputs. 

 

Output A looks like this: 

Total
1200

 

Output B looks like this

GroupCountRunTot_Count
A100100
B200300
C300600
D4001000

 

I am trying to divide all the values in the RunTot_Count Column in Output B by the value of the Total Column in Output A. 

 

Any help will be much appreciated. Thank you very much.

3 REPLIES 3
alexnajm
17 - Castor
17 - Castor

Use the Append Fields tool, followed by the Formula tool to complete your calculation!

usmanbashir
11 - Bolide

@TimBlaze - please see attached workflow. Hope this helps! 

TimBlaze
5 - Atom

Thanks all, Really appreciate it!

Labels