Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!
SOLVED

Creating a while loop equivalent in Alteryx

Highlighted
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.

Highlighted
11 - Bolide

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