community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Adding to Expression "-01" to a value

Highlighted
Dear all, I just want to create a new column. The value of this column should just append the value of an existing column by "-01". For example: the existing value is "150000", I intend to create a new column which is "150000-01". Many thanks for your help in advance. Best regards Dennis
Alteryx Certified Partner
Alteryx Certified Partner

You need to use a formula tool to do this (this allows you to create fields).

 

And then you can use the statement...

 

[MyField]+"-01"

 

This will only work however, if the existing field you want to append to (which I have titled MyField), is already a string, otherwise you may have to use the statement...

 

TOSTRING([MyField])+"-01"

 

Or use a select tool prior to the formula to change the datatype.

 

Ben

Many thanks for the fast support.
Labels