Alteryx Designer Desktop Discussions

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

Conjoin two strings of text based based on name

jrgreen
7 - Meteor

I am needing to conjoin two cells of text and then update my workbook based on the name.

 

So here's the situation. I have one workbook that has all my data and lists the code. I have another workbook that has the code in one column and the name of the code in another. 

 

I am needing to combine the code and the name and have it replace the 'Code' column from my original workbook.

 

In other words. For all the rows in my original workbook that say "ABC", I need to somehow join it based off the proper name. So it would look like "ABC - Code Name 1"

image.pngimage.png
image.png

2 REPLIES 2
Claje
14 - Magnetar

Hi,


There's a few ways to accomplish this, but I would recommend using a Join tool to join on Code from each of your excel files, and then use a Formula with the following formula for the "Code" column.

 

[Code]+'-'+[Name]


Note that you may need to use a Select tool to adjust the size of this Code column so it is large enough to fit the new value, and that if your Codes are numeric, you may need to change [Code] above to TOSTRING([Code]) to map this back.

 

Hope this helps!

CharlieS
17 - Castor
17 - Castor

A Formula tool can combine the code and name to a single value, then use a Find Replace tool to replace the code values in your other sheet. I've attached an example of how to make this happen.

 

 

Labels