Alteryx Designer Desktop Discussions

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

Subtraction using 2 data sets

sbatra116
8 - Asteroid

the solution has to be easily but can't get it. 

 

Dataset 1 

Column IDQuantity
110
214

 

dataset 2 

Subtract_Column
1.00

 

dataset 2 will always have one column. 

Need to substract that number from dataset1.

 

output :

 

 

Column IDQuantity
19
213

 

1 REPLY 1
DataNath
17 - Castor

Hey @sbatra116, you'll just want to use the Append Fields tool for this, which will place an instance of your [Subtract_Column] next to all rows of your main dataset, then you can simply apply a formula:

 

DataNath_0-1655829446270.png

 

Labels