AnsweredAssumed Answered

Split  records into multiple records in another table

Question asked by fruquis on Dec 16, 2012
Latest reply on Jan 3, 2013 by philmodjunk

Title

Split  records into multiple records in another table

Post

     I have a table X  with records

     Every record has a lot of fields 

     Example of one record:

     Name                                                    field Name

     Gross =calculated number                field A 

     code 1                                                  field 1

     Discount / taxes                                   field B

      code 2                                                  field 2

     Net   value A - B    =                          field C

     code 3                                                  field 3

      

     I would like to have a script to split my records from table X and import all  into table Y in the following way

     Every record from table X into three records Table Y 

     record 1   Field Name,Table X , Field D,table Y (=A,tableX),  code 4 (=1,tableX)

     record2 Field NameTable X, Field D, table Y    (=B,tableX) , code 4( =2,tableX)

     record 3 Field name TableX, Field D , table Y   (=C,tableX). code 4 (=3,tableX)

Outcomes