Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Creating a while loop equivalent in Alteryx

96sudeshnasen
7 - Meteor

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.

1 REPLY 1
markcurry
12 - Quasar

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

 

Sum Tables.png

Labels