1 Reply Latest reply: Jul 17, 2017 10:36 AM by Curt Daughtry RSS

    Creating Age Field from Two Different Tables

    Vera Ogdanets

      Hi all!

       

      I am trying to figure out how to create an age field in the load script based on how old participants where when they registered for an event. I have two tables, event and participant. I need to use the Begin_Date in the event table and the DOB in the participant table to calculate age, but I'm struggling on how to pull those two fields out to use them.

       

      I've tried mapping but haven't had success yet. I get an error message that 'Generic tables must contain at least 3 fields'. I've tried taking off the brackets [ ] but that didn't work.


      This is what I have so far, but if anyone knows a simpler or better way to do it, that would be great!


      [BeginDateMap]:

      mapping Load

      [BEGIN_DATE]

      resident event;

       

      [AgeMap]:

      mapping load

      DOB,

      age(ApplyMap('BeginDateMap',Begin_Date,0),[DOB]) as PartAge

      resident participant;