Alteryx designer Discussions

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

Basic Math Question - Two Files?

Highlighted
6 - Meteoroid

Hello,

 

Hope everyone is doing well.

 

I would like to do division on a single value from two separate file.

 

File 1 contains 3 

File 1 contains 5

 

Objective: 3 / 5 = new fields called "Total Score"

 

What tools would I used to accomplish this?

Thanks!

Highlighted
Alteryx
Alteryx

You would need two input files, one for each separate file. You'd use a join tool to combine them on a common field, and then a formula tool for the calculation.

Highlighted
6 - Meteoroid

Thank you.  I'll give that a try

 

Highlighted
Alteryx
Alteryx

See attached for an example. Let me know if this works for you.

 

echuong1_0-1584723487036.png

 

Labels