Hi Alteryx engineer,
I have requirement like below, I have two dataset A and B, I need to check the flag in dataset A and decide to reset the value of responding column in dataset B by using [GROSS] - SUM([B] TO [X]) here the rows of data A is dynamic and the flag could be at any rows. if "Y" is set to F, then I need to reset the [F] in dataset B by [GROSS] - SUM([A] TO [X] except [F])
DATASET A
NAME | FLAG |
A | Y |
B | N |
C | N |
D | N |
E | N |
F | N |
… | … |
X | N |
DATASET B
GROSS | A | B | C | D | E | F | … | X |
7 | -20 | 2 | 3 | 4 | 5 | 6 | 7 |
IF
NAME | FLAG |
A | N |
B | N |
C | N |
D | N |
E | N |
F | Y |
… | … |
X | N |
THEN
GROSS | A | B | C | D | E | F | … | X |
7 | 1 | 2 | 3 | 4 | 5 | -15 | 7 |
The challenge is dataset A has dynamic rows and the flag could be set to any of them
Solved! Go to Solution.