Joining Two Datasources/Tables for a Repeating Group

nate9 · 2024-11-21T06:56:26.027Z

Hello everyone - I’m facing an issue and hope someone can help me out.

I have a Repeating Group (RG) where the datasource/table needs to be joined with another datasource/table. Both datasources contain mostly the same information, but I’m unable to directly populate the first datasource. The second, new table has fewer pieces of information, but I need to append its data to the first table (similar to an SQL outer join).

The “Merge with” function seems to only work within the same table. I haven’t had success with “:plus items” on the Repeating Group.

Has anyone encountered this scenario or have a solution to make this work?

Thanks in advance!

bonjour_17 · 2024-11-21T07:18:39.615Z

Merging tables or adding items only works if both tables are of the exact same type.

If no, there is no way you can merge these.

Maybe a workaround, but NOT AT ALL recommended in term of WU consumption. → work with tables of product ids (list of text) and then do a search for each line of the RG.
If we are dealing with small amount of data that might do the job.

nate9 · 2024-11-21T08:30:16.088Z

Thanks for your response. The second option wont work as there is too much data.

“Merging tables or adding items only works if both tables are of the exact same type” - that would be difficult to navigate as to know which table to populate and reference if they are exactly the same type. Any suggestions in this regard?

cmarchan · 2024-11-21T10:14:38.183Z

Create a data type that “cradles” both. Create text fields in this object that populate through flows instead of pulling it from origin to reduce WUs and speed up things…

system · 2025-01-30T06:57:19.145Z

This topic was automatically closed after 70 days. New replies are no longer allowed.