Summarize- Formula Tool- Join

[gayvaz004]

Muhasebe Kayıt No	Kebir	Borç / Alacak
1	770	B
1	191	B
1	320	A
2	770	B
2	191	B
2	320	A
3	320	B
3	102	A

Muhasebe Kayıt No	Kebir	Borç / Alacak	Muhasebe Kaydı
1	770	B	770B - 191B - 320A
1	191	B	770B - 191B - 320A
1	320	A	770B - 191B - 320A
2	770	B	770B - 191B - 320A
2	191	B	770B - 191B - 320A
2	320	A	770B - 191B - 320A
3	320	B	320B - 102A
3	102	A	320B - 102A

 I want to turn my 1st table into 2nd table.

Could you help me with this.

Thank you.

[JosephSerpis · Accepted solution]

Hi @gayvaz004 I mocked up a workflow let me know what you think?

[gayvaz004]

Thank you for your prompt reply.

When I tried to apply your solution on my own; I couldnt use the concat action on Summarize tool.

How can I use this action in Summarize tool?

Than you? 

[JosephSerpis]

Hi @gayvaz004 the concatenate function will only work on string fields you need to select the relevant field then select add and then the option to Concatenate in string functions should be available.

   

Once you have Concatenated your field you can select the separator.

[BenMoss]

Hi!

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

Learn more about Accepted Solutions here.

Thank you!