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?
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.
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?
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…
