Pipeline to Pre-fill a many to many table triggered by the addition of Parent Records

Question

I have a many to many table that includes a distance value between 2 related parent table records. When either a Parent 1 or Parent 2 record is added I want to create a record in the many to many table ... result being that for each Parent 2 there will be distance for Parent 1. Currently there are 300 records in Parent 1 and 60 records in Parent 2. I have manually imported from a csv 18000 records in to the many to many table.

What does the pipeline look like that creates additonal records automatically when either a Parent 1 or Parent 2 record is added.

------------------------------
George Bramhall
------------------------------

MarkShnierYou · Answer

It will be two separate pipelines.Pipeline 1Trigger on Parent 1 Created.Create a bulk upsertSearch all Table B Records.For each loop - add upsert row (creating those middle join records) Then outside the loop .. commit upsert.Then similar but opposite for Parent 2 created.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Sign up

Login to the community