looping

96sudeshnasen

loopHi,

I have a very specific problem in Alteryx.

I have two tables:

Table 1:

Cost_to_be_added

200

130

120

100

Table 2:

Salesman	Cost
Bob	30
Robin	35
Ted	36
Lilly	40
Tracy	45

Now I would like to add the costs of table 1 to the row in table 2 who has the lowest cost. So that the first entry of table 1 '200' will be added to Bob. So the table looks like this now:

Calculated Table (First iteration):

Table 2:

Salesman	Cost
Bob	230
Robin	35
Ted	36
Lilly	40
Tracy	45

After this addition, we check who now has the lowest cost. This will be Robin.So we take the next value from Table 1: '130' and add it to Robin's cost.

So now the table will be:

Calculated Table (Second iteration):

Table 2:

Salesman	Cost
Bob	230
Robin	165
Ted	36
Lilly	40
Tracy	45

Again we check for the person with the lowest cost and add the third value of table 1 to his/her cost. This process repeats until all the values of Table 1 has been added to Table 2.

This can be achieved simply using some programming language but as a part of my work, I've to implement this in Alteryx.

Any suggestions would be appreciated.

Workflow

Datasets

Python

Batch Macro

Join

Adobe

Accepted answers

ponraj

This part is to find last iteration(19th iteration in this example) and to eliminate other unnecessary iterations records. This part makes the workflow dynamic.

All comments

MarqueeCrew

Hint: you're looking for an iterative macro.

cheers,

mark

96sudeshnasen

Hi,

I looked into iterative macros but how do I remove the values from Table 1 that has already been used in the first iteration?

Thanks,

Sudeshna

ponraj

Here is the sample workflow. Hope this is helpful.

looping.yxzp

96sudeshnasen

Hi,

Thanks a lot! This worked.

But can you explain what the part shown in the image attached is doing? I can understand that it is picking out the last iteration where all the Salesman names are present (ie count =5) but if after that iteration, any values for Cost changes, how will that be picked up?

Thanks,

Sudeshna

ponraj

This part is to find last iteration(19th iteration in this example) and to eliminate other unnecessary iterations records. This part makes the workflow dynamic.

96sudeshnasen

I've an added layer of problem now. There is an extra field in both he table: "Team" and I've to run this entire process for each of the teams separately. How to do that without manually running it after separating the files by teams?

ponraj

Possible to share sample data?

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335