Concatenating Text
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
Happy Friday!..I am trying to join text ( first name,middle name and last name ) into a separate column with the first name ,middle name and last name seperated by a space...Can you please let me know what formula needs to be used to accomplish this in alteryx..
Thanks,
Arun
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@arunchandra You can use the + sign when working with strings to concatenate:
[FirstName] + " " + [MiddleName] + " " + [LastName]
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I need help in the getting the needed output.
Please see below screenshot.
Need to get output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @iceman,
1. First transpose by taking "key field" as CC no. and remaining fields will be as "data fields".
2. Then filter out the null records.
3. Now cross-tab by grouping CC no field, make field consisting A1, B1, C1.. as Headers and field containing names as Values and then concatenate it without using any separator.
Above steps will surely serve your purpose.
Thanks,
Vishwa
@icemanwrote:Hello,
I need help in the getting the needed output.
Please see below screenshot.
Need to get output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @vishwa_0308
Thank you for your quick response.
I don't quite understand as to how am I going to do it in Alteryx. Do you have like a sample flow as to how it works?
I apologize about this as I am a beginner using the tool.
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @vishwa_0308
May I have a copy of this file that you have screenshot?
I appreciate if you can send me the file.
Thank you for your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
