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!