I have an object (table) that I want to populate with a set of template rows that will be stored in another object (table).
Let me sketch this out a bit:
RecId Name Level Group Factor Data6 Data7 ...<br>----- ---- ----- ----- ------ ----- ----- ...
RecId Name Level Group Factor Condition1 Condition2<br>ab001 1234 1 A Red Thursday Dent<br>ab002 1235 1 A Blue Thursday Dent<br>ab003 1236 2 A Yellow Thursday Dent<br>ab004 1237 1 A Red Monday Dent<br>ab005 1238 2 B White Monday Dent<br>ab006 1239 1 A Blue Monday Prefect<br>ab007 1240 2 B Green Thursday Prefect
I would have a model based on the Source object, with conditions for selecting by day and by person. I will query the model. If the condition values are Monday and Dent, the model will contain 2 rows: Level 1, Group A, Factor Red; and Level 2, Group B, Factor White.
I want to copy these 2 rows into my Target model, as…
RecId Name Level Group Factor Data6 Data7 ...<br>ar01a 2468 1 A Red ----- ----- ...<br>ar01b 2469 2 B White ----- ----- ...
Will this work?