Is there any better way than the one shown in the image of merging the text from two repeating groups(Different Datatype). I tried using merged with but that Deduplicates the results and only gives unique values.
Could you clarify a little better what you want to do?
Do you want to take a list of texts from a repeater group and merge it with another list of texts? Is that it? Try to explain your problem a little better.
Yes, you got it right. I want to take a list of texts from a repeating group and merge it with another list of texts from another repeating group
For Example:
RG 1 (Datatype1)
RG 2 (Datatype2)
Take comments field from RG1 and summary field from RG2 and merge them together without deduplication.
Thanks
huhhh ok. But then why do you use other things in your screenshot? Like “join with”, “JSON-safe”, “format as text”?
To just join two text lists, you could just do this:
RG1's List of Datatype1:each item's comments:merged with RG2's List of Datatype2:each item's summary
What else do you need in this text list?
As I said, I don’t want deduplicated results. :merged with only returns the unique values
I think I’m starting to understand, you don’t want to use merge with, because it will return unique values. It was confusing, but I got it.
So you can do something really simple instead, it would look something like this:
RG1's List of Datatype1:format as text append RG2's List of Datatype2:format as text
And inside format as text, you put the text, and in the delimiter a comma or whatever you prefer.
Here’s a screenshot below to make it clearer:
The text:
Inside the format as text:
