Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Join two tables, looping through the values in one

SergeantJack
8 - Asteroid

Hi, here is my problem, simplified:

 

Table1:

Alabama

Alaska

Arizona

Arkansas

California

Colorado

Connecticut

Delaware

Florida

Georgia

 

Table2:

red

white

blue

 

I want to join the two tables such that the join loops through Table2 and connects its values to Table1 until Table1 is finished, so the end result will look like this:

 

Joined Table:

Column1       Column2

Alabama       red

Alaska          white

Arizona         blue

Arkansas      red

California      white

Colorado       blue

Connecticut   red

Delaware       white

Florida           blue

Georgia         red

 

How do I do this?  

2 REPLIES 2
Felipe_Ribeir0
16 - Nebula

Hi @SergeantJack 

 

One wayof doing this

 

Felipe_Ribeir0_0-1665527484656.png

 

SergeantJack
8 - Asteroid

That worked perfectly.  Thanks for the quick solution!

Labels