Add single value to column of existing table, and repeat it for each row

[omar_velor]

Hi all,

Can you give me a hand to achieve the following task in Alteryx?

Considering the simple table,

ID	Country
1	FR
2	UK
3	BE
4	DE

I want to add a third column which will have the same entry for each row, based on another table in the workflow,

Stage

Done

The final table should look like this,

ID	Country	Stage
1	FR	Done
2	UK	Done
3	BE	Done
4	DE	Done

Cheers

[FinnCharlton · Accepted solution]

Hi @omar_velor , you're looking for the append fields tool:

[acarter881]

Hello, @omar_velor.

Append fields is the way to go; please see screenshot and attached workflow.