I have two tables that form a child parent relationship. The parent record has a primary key and some field data, and the child record has a foreign key and some field data. I am trying to append each child record's field data onto the end of each parent record. There can be anywhere between 1 and 99 child records for every parent record, and the field names from the child record should be repeating.
I have attached some sample data to show what I am trying to achieve. The spreadsheet contains a parent table, a child table, and a final table showing the desired final format.
Parent:
Child:
Final:
It basically look something like this:
Parent Table:
Parent-Field 1 (Key) | Parent-Field 2
Child Table:
Child-Field 1 (F-Key) | Child-Field 2 | Child-Field 3
Final Table:
Parent-Field 1 (Key) | Parent-Field 2 | Child-Field 2 {0} | Child-Field 3 {0} | Child-Field 2 {n} | Child-Field 3 {n}
I have tried using aggregators, feature joiners, database joiners, aggregators, list builders, and splitters, but I can't seem to get it working. The data is freeform, so I want to try and stay away from concatenations if possible.
Again, this is a simplified version of the data I am looking at translating. To do this process manually takes several hours, and consists of thousands of records between the parent and child tables.