Concatenating based on

I have a list of people with a description of their goals. Since they are also earning points, I need to use a summary tool, and before that would like to concatenate the goals based on the person's first name.

Help would be much appreciated! Thanks!

Developer

Accepted answers

atcodedog05

Hi @insomned

Similar to @AngelosPachis suggested it would be like this.

Workflow:

Hope this helps : )

goals.yxmd

All comments

bensilv

Hi @insomned, what do you mean by concatenate based on the person's first name? Could you share an example of what you would expect to see?

To concatenate in the formula tool, you would just need to use the + sign.

E.g. to concatenate "John" in [First Name] and "Smith" in [Last Name], it would simply be [First Name] + [Last Name]

AngelosPachis

Hi @insomned ,

Assuming that your input looks similar to this

You can use a summarize tool to group by the person's name, concatenate their goals and sum the points.

Hope that's what you're after.

Cheers,

Angelos

example.yxmd

atcodedog05

Hi @insomned

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

insomned

For example,

Goals Person

X John

Y John

Z Mary

I would need to have a column with X, Y for John, and so on.

atcodedog05

Hi @insomned

Similar to @AngelosPachis suggested it would be like this.

Workflow:

Hope this helps : )

goals.yxmd

insomned

Super helpful, thanks everyone!

atcodedog05

Happy to help : ) @insomned

Cheers and have a nice day!

insomned

Thanks, and have a nice day You too!!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703