Creating a while loop equivalent in Alteryx

[96sudeshnasen]

Hi, 

I have a very specific problem in Alteryx.

I have two tables:

Table 1: 

Cost

200

130

120

100

98

55

54

54

50

30

25

24

18

10

9

8

2

1

1

Table 2:

Cost 

30

35

36

40

45

Now I would like to add the costs of table to table to serially ie

Calculated Table:

Total_cost:

30+200

35+130

36+120

40+100

45+98

Now with the costs left over from table 1, I would like to start adding them to table 2 again from the top. This process will repeat until all the costs of table 1 has been added to table 2:

Calculated Table:

Total cost:

30+200+55+25+8

35+130+54+24+2

36+120+54+18+1

40+100+50+10+1

45+98+30+9

I don't know how to do this in Alteryx.

[markcurry · Accepted solution]

You would use an iterative macro to do loops in Alteryx, but in this case you can use a simple workflow, see attached...