Add a fixed value to all cells in a column

Question

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 Answer

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 Answer

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.

JVMORO · Accepted Answer

Hi Pablo,

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

DateTimeFormat(DateTimeToday(), "%Y")