Hi everyone,
I have sets of data that can be categorized/grouped by a numeric ID. In my example I'm trying to work with I can tell what each category based on the mapped_names field for each ID. For example:
ID = 1
Mapped Name = Cat
Mapped Name = Dog
I'd call this example Cat + Dog
ID = 2
Mapped Name = Cat
Mapped Name = Dog
Mapped Name = Dog
I'd still call this example Cat + Dog
ID = 3
Mapped Name = Cat
Mapped Name = Cat
Mapped Name = Cat
I'd call this example Cat
I'm trying to filter my data by concatenating my mapped_name field and looking for certain combinations. The problem is when there are too many values I get an error telling me that the record is too big. I don't think the record would ever be too big if my values I were concatenating are distinct as I believe I only have 12 distinct values in my large dataset. I've attached an example. Is there a way to concatenate distinct values for an ID rather than every value that falls under the same ID?
My last question as you'll see from my example is why won't the mapped names appear all together? Each value still has its own separate line. Thanks in advance.
