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-01 | US |
| 2024-01-01 | CA |
| 2024-01-01 | AU |
| 2024-01-02 | US |
| 2024-01-02 | CA |
| 2024-01-02 | AU |
| 2024-01-03 | US |
| 2024-01-03 | CA |
| 2024-01-03 | AU |
How can I achieve this, any help is greatly appreciated
Solved! Go to Solution.
@Rag1
Looks like we can use Append tool.
Thanks, and it works fine!

