2 Replies Latest reply: Mar 18, 2011 7:43 AM by mikefardell RSS

    How can I create a derived field in load script based on two sources???

      Hello...

      I can add derived fields in the script in each individual load source but...

      I can't figure out how to add a derived field based on a field from each of the 2 sources...

      This is the field I want to create:

      IF(DATE_OF_ORDER >= INCEPTION_DATE, 'TRUE', 'FALSE') AS T1;

       

      In this load script:

       

      ODBC CONNECT TO Blah (XUserId is ZJTREVFLZGHXcMSLZKGXVT, XPassword is DKLBJOPbaKGZFHKE);


      TRACKER:

      LOAD

      "DATE_OF_ORDER",
      "POLICY_NO";
      SQL SELECT * FROM TRACKER;

      POLICY:

      LOAD

      "INCEPTION_DATE",
      "POLICY_NO";
      SQL SELECT * FROM POLICY;

       

      Any advice most welcome... thanks, Mike