Alteryx Designer Desktop Discussions

BRRLL99 · ‎04-15-2024

Hi ,

I have following data set

Row	DEAL TYPE	CUSTOMER - ID	AMOUNT
1	7	100A	100
2	CA	100A	-100
3	CA	100A	100
4	01	7059	96891.8
5	01	7059	-96887.65
6	04	7059	-851.5
7	04	7059	-4.15
8	04	7059	4.15
9	77	7059	851.5
10	88	7059	-4.15
11	99	200A	200
12	39	200A	-200
13	39	200A	200
14	99	200A	200
15	99	400A	-200
16	39	400A	-200

Rules : for Expected output

1. Deal type should not be same and Amount should be "+" and "-" then it is Match
ex: row 1 and 2 deal type is different and amount 100 is positive and negative then it is Match

2. Based on customer id sum of different Amounts needs to be offset with remaining amount.

ex: from row 4 to 10 we have same customer id's 851.5 is offset with -851.5 with different deal type same for 4.15

for -96887.65 it will be sum of row 5 and row 7 within same id

Expected output:

Row	DEAL TYPE	CUSTOMER - ID	AMOUNT
1	7	100A	100	M
2	CA	100A	-100	M
3	CA	100A	100
4	01	7059	96891.8	M
5	01	7059	-96887.65	M
6	04	7059	-851.5	M
7	04	7059	-4.15	M
8	04	7059	4.15	M
9	77	7059	851.5	M
10	88	7059	-4.15	m
11	99	200A	200	M
12	39	200A	-200	M
13	39	200A	200	M
14	99	200A	200	M
15	99	400A	-200	M
16	39	400A	-200	M