4 Replies Latest reply: Oct 23, 2014 9:43 AM by anbu cheliyan RSS

    Load a file with sql conditioning to another file

      Hi, i've to load a file but the records must be conditioning to another load.

       

      Example:

      LOAD

        A  as [key1], B  as [CodeFile01_B], C  as [CodeFile01_C];

      SQL

         select A, B, C from lib01.File01;

       

       

      LOAD

        A  as [key1], B  as [CodeFile02_B], C  as [CodeFile02_C], D  as [CodeFile02_D], where exists(A);

      SQL

         select AA, BB, CC, DD from libe02.File02;

       

      The record of File02 must be load if this exist in File01.

       

      Can i make this operation?

      If i launch the script there isn't any error but the second load doesn't load any record!

       

      Thanks.