Alteryx Designer Desktop Discussions

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

Add a fixed value to all cells in a column

PabloMU
5 - Atom

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

 

Screenshot 2023-08-22 111510.jpg

6 REPLIES 6
OllieClarke
15 - Aurora
15 - Aurora

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
12 - Quasar

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.

Append Fields.PNG

Append Output.PNG

PabloMU
5 - Atom

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
7 - Meteor

Hi Pablo,

 

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

DateTimeFormat(DateTimeToday(), "%Y")

OllieClarke
15 - Aurora
15 - Aurora

@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
5 - Atom

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

Labels