Skip to main content
Question

Concatenating Strings from Multiple Rows

  • November 6, 2025
  • 2 replies
  • 44 views
J
Forum|alt.badge.img

I’ve been thinking about how I can do this, but am coming up short. In a simple example, this is what the data looks like:

ID1 / String1
ID1 / String2
ID2 / String3
ID2/ String4
ID2 / String5

The end result of my data design is that I want to concat all the strings for each ID like this

ID1 / String1 String2
ID2 / String3 String4 String5

Can anyone help me think of a way to accomplish this? Thanks!

    2 replies

    Jef Vanlaer
    Forum|alt.badge.img+2
    • Jef Vanlaer
    • Helper ⭐️⭐️
    • November 7, 2025

    Hi ​@jschwegler 

    Are these strings pre-defined options (so a limited set)? If so, you could use filters to pull in rows with String 1, String 2, etc. separately and then merge all of these based on the ID before concatenating the columns.

    If they are random strings, I need to think longer on this. Don’t immediately see a way to do it either.

    Kind regards,
    Jef

    J
    Forum|alt.badge.img
    • jschwegler
    • Author
    • Contributor ⭐️⭐️
    • November 7, 2025

    Hey ​@Jef Vanlaer, sadly no. There could be one string, there could be 3, no pattern between them. What I'm actually trying to do is use the AI Cheat Sheet MDA object and list the latest statement in the renewal discussion category. That works fine with max of create date, but it's possible to have more than one sentence created on the same day, so I wanted to combine them.

     

    I thought this would be a neat idea for our renewal dashboard to have this information in a table, but I dont want to have 2 or more rows for each customer the qualifies the filters.

    Terms & ConditionsCookie settingsAccessibility statement