Concatenating Text

[arunchandra]

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

[patrick_digan]

@arunchandra You can use the + sign when working with strings to concatenate:

[FirstName] + " " + [MiddleName] + " " + [LastName]

[iceman]

Hello,

I need help in the getting the needed output.

Please see below screenshot.

Need to get output

[vishwa_0308]

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

---

[iceman]

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 

[vishwa_0308]

[iceman]

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.

[vishwa_0308]

Sorry for now..m not able to send the workflow..you can use the tools as shown and configure it as given..there is no such difficult configuration.

[derekbelyea]

Have a look at this.  File attached.

   

[iceman]

Thank you @vishwa_0308 and @derekbelyea for assisting me on the issue. The suggestion that you have given me works.

However, I have another scenario.

Below is a sample output that I have on my other project.

Thank you