Can anyone help me in deriving the logic of consolidating and updating from a repeating group by creating a new thing.
below is the data from the repeating group (Purchase details)
when I click submit, I need a logic to create a new thing which consolidates the vendor name and adds the Item list to the particular vendor as shown below.
the puchased IDs are created based on no of unique vendors.
Sharing my Application incase if you need for more details.
Appreciate your help.