Skip to main content
Question

pipeline to copy form two tables to one

  • Apr 4, 2025 11:20 AM UTC
  • 1 reply
  • 55 views

Forum|alt.badge.img+1

Hi all, 

I have 3 tables, one for store, one for master material and one for data output for running pipelines. The pipeline is based on a trigger initiating form the store table where i tick say 'coffee pack' when i create a store which then copies anything from the master material table to the data output table. This all works fine and say if i had a trigger to copy tea products based on another trigger for 'Tea Pack' when i create a store it will just copy the tea output to the data output table. If i select both coffee and tea packs on the store table it copies all products with tea and coffee in the allocation field used in the material master.

however, i want to be able to transpose the store information into the data output field also like store name. The data file will then show the products in the data output and have the store requested name against each product. Is this possible?

 

 

1 reply

Top Step
Forum|alt.badge.img+12
  • Observing
  • Oct 28, 2026 10:56 PM UTC

Yes. In the step that creates each Data Output record, you can map fields from the trigger step as well as from the material record you’re looping on.

So next to the product fields, set your store name field from the trigger:

{{a.store_name}}

Better yet, make Data Output a child of Store and set Related Store to {{a.id}}. Then a lookup brings in Store Name and any other store fields without copying them, and each store gets an embedded report of all its products.

If you’re using the bulk copy step and it won’t let you map trigger fields, switch to a Search Records step on Master Material with a For each that runs Create Record.