Alteryx Designer Desktop Discussions

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

Help with Logic

Arcane
7 - Meteor

Hi, below are the sample tables. I am trying to merge the two tables, with missing rows to form a complete table.

 

Year TokenID Description
2020 1 Token 1
2020 2 Token 2
2020 4 Token 4
2020 5 Token 5
2020 6 Token 6
2020 8 Token 8
2020 10 Token 10
2019 1 Token 1
2019 2 Token 2
2019 4 Token 4
2019 5 Token 5
2019 6 Token 6
2019 8 Token 8
2019 10 Token 10

TokenID Description
3 Token 3
7 Token 7
9 Token 9



Year TokenID Description
2020 1 Token 1
2020 2 Token 2
2020 3 Token 3
2020 4 Token 4
2020 5 Token 5
2020 6 Token 6
2020 7 Token 7
2020 8 Token 8
2020 9 Token 9
2020 10 Token 10
2019 1 Token 1
2019 2 Token 2
2019 3 Token 3
2019 4 Token 4
2019 5 Token 5
2019 6 Token 6
2019 7 Token 7
2019 8 Token 8
2019 9 Token 9
2019 10 Token 10

 

Thanks in advance.

 

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @Arcane 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1646061152852.png

 

Hope this helps : )

 

Labels