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:
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |