pipeline to copy form two tables to one
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?