5 Replies Latest reply: Jul 29, 2015 10:16 AM by Gysbert Wassenaar RSS

    Load: Compare with other resident table field

    Hanuman Guntupalli

      How can I load a resident table comparing(where ) a field with other resident table field.

       

      Resident1:

      LOAD

      ID,

      PR_NUM,

      PO_NUM,

      REQUESTOR

      PR_Amount;

      RESIDENT PR_XYZ;

       

      Now I am loading whole records in to PO_OPEX table.

      PO_OPEX:

      LOAD

      ID,

      PO_NUM,

      REQUESTOR

      PR_Amount;

      SQL Select * from PO_OPEX;

       

      I want to create a resident table as a subset of PO_OPEX which matches with a field in Resident1

      Resident2:

      LOAD

      LOAD

      ID,

      PO_NUM,

      REQUESTOR

      PR_Amount;

      RESIDENT PO_OPEX WHERE Resident1.REQUESTOR Match('abc','xy'):


      Here is the problem Loading Resident2 by checking with Resident1.REQUESTOR.
      How to achieve this.

      Concatenate  or Join. pls provide sample syntax.