Add a fixed value to all cells in a column

[PabloMU]

Hello Community:

I want to add a single value to a column that repeats for all rows in my table. This value would be the Fiscal Year and I need to bring from an excel input (to avoid changing the Alteryx each year).

So far, all the options i found are relational but that force me to have the same structure or otherwise it will create new rows for the new relations, i would like to find a different solution.

thx in advance,

Pablo

[OllieClarke · Accepted solution]

Hi @PabloMU 

Use the Append Fields tool, with your Fiscal Year attached to the Source input, and your other table attached to the Target input

https://help.alteryx.com/20231/designer/append-fields-tool

Hope that helps,

Ollie

[Prometheus · Accepted solution]

You can use the Text Input tool with your column header and single value then use the Append Fields tool to bring that value in to every row on a single column.

 

 

[PabloMU]

Thx so much Ollie, i just applied the tool and it worked. I thought append would work as a union or join instead.

Thx for your help!

[JVMORO · Accepted solution]

Hi Pablo,

You could use a simple formula inside the "formula" component, I think this already fits what you need

DateTimeFormat(DateTimeToday(), "%Y")

[OllieClarke]

@PabloMU the Append Fields tool will place every record from the Source input against every record in the Target input (otherwise known as a cartesian or cross join). 
It's akin to both streams having a field which is '1' that is joined on

Ollie

[PabloMU]

thx so much all for the super quick and helpful help.