I am looking for a way to Text Join with conditions in Looker. In excel, I used to do a simple formula like shown in the snapshot below. In detail, I have to join a set of names in (let’s say) column C if they have in common values in column B.
Is it possible to solve this puzzle via a Table Calculation?
Thank you beforehand for the prompt reply!