In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Prefix a column with a word

nmotiani
7 - Meteor
‎06-25-2024 01:59 PM

Current Field:

CompanyID
Skittles1234
Cadbury5678

 

Desired Output:

CompanyIDCompany ID
Skittles1234Skittles1234
Cadbury5678Cadbury5678
Labels:
Reply
0 Likes
2 REPLIES 2
Bren_Spill2
12 - Quasar
12 - Quasar
‎06-25-2024 02:09 PM

Use a formula tool to create a new column called Company ID and formula [Company] + [ID]

 

If [ID] is numeric then [Company] + tostring([ID])

Reply
0 Likes
Bren_Spill2
12 - Quasar
12 - Quasar
‎06-25-2024 02:13 PM

image.png

Reply
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All