We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Join and multiply two columns

Rag1
6 - Meteoroid

I have a date column and country column separately. I want to club these and each date should have all the countries associated with it.  Sample below

Date

2024-01-01
2024-01-02
2014-01-03

 

Country

US
CA
AU

 

Final output Table:

2024-01-01US
2024-01-01CA
2024-01-01AU
2024-01-02US
2024-01-02CA
2024-01-02AU
2024-01-03US
2024-01-03CA
2024-01-03AU

 

How can I achieve this, any help is greatly appreciated

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@Rag1 
Looks like we can use Append tool.

Qiu
21 - Polaris
21 - Polaris

A quick sample

1217-Rag1.png

Rag1
6 - Meteoroid

Thanks, and it works fine!

Labels
Top Solution Authors