2 Replies Latest reply: Jan 1, 2018 4:51 AM by Avinash R RSS

    Applymap one to many

    yusuuf rawat

      "Whenever there is a one to many relationship between tables then a separate table must be loaded into the data model instead of using a mapping table and applymap."


      Ive read the existing threads and tested using an example and the above statement doesnt make sense.


      As long as the mapping function values are distinct the other table can have duplicate values, they will be correctly mapped. So a 1 to many relationship does work. It wont work on many to many relationship or on a one to many only if the mapping function values are the many. As long as the mapping function values are distinct the function will work correctly.


      Eg maptable:

      Load * in line [

      A

      One

      Two

      Three

      ] ;


      If the table being mapped to has many 1, 1, 1, it will still work, so one to many works just depends on which table is the many, the maptable cant be the many.

      Correct me if im wrong