Convenient way to implement dynamic columns requirement

[187]

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

[Christina_H · Accepted solution]

I think this does what you need

[187]

@Christina_H  

this is great, thanks for your help