23 Replies Latest reply: May 16, 2013 4:26 AM by Dan-Ketil Jakobsen RSS

    Remove null data in load

    Dan-Ketil Jakobsen

      Hi

       

      I need to remove data where records show null for a spesific field. I cannot do this in the sql query because I need it in yet another load

       

      I have a code lookin like the one below.

      I started out with one load, but have read several postes that susggest that I should do a noconcatenate load as well.

      In the Stopp load I add a where clause and have tried 3 different methods.

      But still my table box from Stopp will show trucks that have null.

       

      Stopp1:

      LOAD

      truck & '-' & min_lic AS KEY3,

      ,truck as truck3

      .min_lic as min_lic3

      .load_time as StoppTime3

      ,IsNull(truck) as NULLID;

       

      SQL select bla bla.....

       

      NoConcatenate

       

      Stopp:

      Load

      KEY3 AS KEY,

      truck3 as truck,

      min_lic3 as min_lic,

      StoppTime3 as StoppTime,

      NULLID;

       

      RESIDENT Stopp1

      WHERE

      not IsNull(truck3); // TEST 3

      //NULLID;= 0;        // TEST 2   

      //len([truck3])>0;  // TEST 1

       

       

      DROP Table Stopp1:

       

      BR

      Dan