Map to filed with multi-row variable sets.

aok7
Tera Contributor

Hi all,

 

when creating a record producer, I see I can check the map-to-field box to map values to the generated record on the associated table. I don't see this option for the multi-row variable set questions (or it disappears after a few seconds), so I have 2 questions

  1. Is it possible to map from a multi-row variable set?
  2. If yes, will each row create a separate record in the associated table?

A simple example, I have a record producer that captures details such as item name, quantity and cost for a cost estimate with multiple line items. I'd like to map the values to similar fields in say, the Cost Plan table.

 

Any additional considerations and best practices would be appreciated.

 

Best

2 REPLIES 2

Brad Bowman
Kilo Patron
Kilo Patron

You cannot map a MRVS variable to a field because there could be many rows, so many values mapped to the same field wouldn't work.  If you want each row to create a new record on the Record Producer target table, or a different one, you might be able to do something like that in the Script field of the Record Producer - taking the contents of the MRVS plus any variables that are outside the MRVS common to all new records and run a loop that creates the records.  Would be fun to try.

@Brad Bowman  Got it! Thanks for the quick response.