Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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