HI Team, I have a data set that i need to merge. Data set 1 ID1 2 3 4 Data Set 2 IDNames1Alpha1Beta2Gamma3Test3Alpha4Test14Beta4Gamma4Alpha Desired Output: IDNames1* Alpha * Beta 2Gamma3* Test * Alpha 4* Test1 * Beta * Gamma * Alpha Appreciate if someone can help me in the right direction.

@cjaneczko Solution should work for you. If you need the bullet point format you would need to add a condition for that to separate 1 entry vs multiple. An output tool might not work for the bullet point format so better use table tool (add the condition/logic here for the bullet point) then render tool for your output.

Join two columns on multiple values and combine them in one cell in excel

SouravKayal

HI Team,

I have a data set that i need to merge.

Data set 1

Data Set 2

ID	Names
1	Alpha
1	Beta
2	Gamma
3	Test
3	Alpha
4	Test1
4	Beta
4	Gamma
4	Alpha

Desired Output:

ID	Names
1	Alpha Beta
2	Gamma
3	Test Alpha
4	Test1 Beta Gamma Alpha

Appreciate if someone can help me in the right direction.

Reporting

Parse

Accepted answers

All comments

Jay-RDC

Hi, Join Tool should work and just join them by ID.

SouravKayal

Join tool will get them in different rows i want to show them under 1 row if multiple values seprated by bullets or a delimiter

cjaneczko

You can use a Summary Tool and group by ID and Concatenate by Name. You only need Dataset 2 in this instance. I dont think you can use a bullet, but you can use any other delimiter you can think of.

SouravKayal

can you help with a test workflow ?

MilindG

@SouravKayal

Join.yxmd

cjaneczko

Add a sort tool after it if you want the ID's in order.

Raj

@SouravKayalare you looking for output in PDF output or Xlsx format.
have you explored reporting tools?

cjaneczko

If its in excel you can also use \n in stead of the comma as the separator and it will put a Carriage return inside the cell and present it just like you have it, less the bullet.

kamal03

Hi @SouravKayal

Simple summarization tool can provide you with the desired output.

I have created workflow, please check that if aligns with your requirement.

Note: Bullet point thing i am not sure about if that works in Alteryx.

SouravKayal.yxmd

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335