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