Add new records that match with an existing field in the main table

[sarasustelosantos]

Hello,

I have this table as the main one:

Year	ID
2016	1
2017	1
2018	1
2016	2
2017	2
2018	2
2016	3
2017	3
2018	3

And I have a second table with new year data:

Year

2019

2020

2021

2022

As an output the result should be a table that adds to the main one, the new year with each existing ID.

Year	ID
2016	1
2017	1
2018	1
2016	2
2017	2
2018	2
2016	3
2017	3
2018	3
2019	1
2020	1
2021	1
2022	1
2019	2
2020	2
2021	2
2022	2
2019	3
2020	3
2021	3
2022	3

How can I do this in Alteryx?

Thank you in advance 🙂

[grazitti_sapna · Accepted solution]

Hi @sarasustelosantos , try this if works for you.

Thanks.

[ChrisTX]

The attached workflow gives the requested output.

 

Chris

[ropra]

 Hey,

Attached a workflow - if the fields that need to be appended are a lot, it would take some time to process