Concatenating Multi-value Field.

[mike_weaver]

I am trying to concatenate two fields, one of which has multiple values, separated by comma.

I have this:

1	a,b,c
2	a,b
3	a,b,c,d

What I'd like to get to is:

1-a,1-b,1-c

2-a,2-b

3-a,3-b,3-c,3-d

I'm not quite sure how to get there and any help would be appreciated.

[AngelosPachis · Accepted solution]

Hi @mike_weaver ,

I've mocked a workflow that answers your question. Please let me know if that's your desired solution.

Hope that helps.

Regards,

Angelos

[mike_weaver]

Perfect! Thanks so much, I was just having trouble wrapping my head around it.

Also, thank you for responding so quickly!

[AngelosPachis]

No worries @mike_weaver , I'm glad I was able to help 🙂

[Qiu]

@mike_weaver 
@AngelosPachis gives a very flow.

And I tried with one Formula tool. Hope you can accept it.

[mike_weaver]

That is nice, Qiu. So it grabs every one that starts with a comma first, then gets the first character.

I will definitely remember that.