the solution has to be easily but can't get it.
Dataset 1
| Column ID | Quantity |
| 1 | 10 |
| 2 | 14 |
dataset 2
| Subtract_Column |
| 1.00 |
dataset 2 will always have one column.
Need to substract that number from dataset1.
output :
| Column ID | Quantity |
| 1 | 9 |
| 2 | 13 |
Solved! Go to Solution.
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:

