Add different combinations of row values

rickydata

I have the following data

Item | code

item 1 | A

item 1 | B

item 1 | C

But I want to combine codes with a different combination of other codes for the same item

Item | code

item 1 | A

item 1 | B

item 1 | C

item 1 | AB

item 1 | AC

item 1 | BA

item 1 | BC

item 1 | CA

item 1 | CB

Developer

Developer Tools

Accepted answers

AGilbert

Iterative macro attached which applies the same logic as before but to each group in order.

FYI the max iterations is set to 100 by default but can be changed in Interface Designer -> Properties.

I made the assumption that your groups are literally called '1' and '2' and used those values to match to the iteration number of the macro (see filter tool). If you're actually passing strings as test names, we will need to refactor a little.

05132024_rickydata.yxzp

All comments

AGilbert

Should AA, BB and CC be included in the output or not?

Edited: The attached workflow matches your output. If you want the AA, BB, and CC values just remove the conditional expression and replace it with the concatenation of the code and source fields.

Screenshot 2024-05-13 161505.png

05132024_rickydata.yxmd

rickydata

I should have mentioned that the first column could have mulitple values and the code field could have varying values.

Let me attach an example.

Alteryx Help.xlsx

AGilbert

Iterative macro attached which applies the same logic as before but to each group in order.

FYI the max iterations is set to 100 by default but can be changed in Interface Designer -> Properties.

05132024_rickydata.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703