ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

Basic Math Question - Two Files?

djspring
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!

echuong1
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.

djspring
6 - Meteoroid

Thank you.  I'll give that a try 🙂

 

echuong1
Alteryx
Alteryx

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

 

echuong1_0-1584723487036.png

 

Labels