15 Replies Latest reply: Nov 15, 2017 5:21 PM by Fabrizio Giorgio RSS

    Resident Load where a field is Not Null

    Fabrizio Giorgio

      Hi all,

       

      This should be a simple statement but i cannot get it to work for me...

       

      I have a table loaded from my Database via ODBC...

       

      I need to clean up a table by only loading rows where the field "ISHRDebName" is not NULL

       

      Here's my script:

       

      ISHRBProductLists:

      Load

      ISHRBSKU,

      ISHRBListMastID,

      ISHRBListDescription,

      ISHRBDebAcc,

      ISHRBDebName

      Resident ISHRBProductLists_temp WHERE Len(Trim(ISHRBDebName))>0;


      I have tried: (last line)

      Resident ISHRBProductLists_temp WHERE Len(ISHRBDebName)>0;


      I have also tried:

      Resident ISHRBProductLists_temp WHERE NOT ISNull(ISHRBDebName);


      I have also tried:

      Resident ISHRBProductLists_temp WHERE ISNull(ISHRBDebName)=0;

       

      here's the table I'm loading from:

      product lists table.jpg

       

      I need to omit rows where ISHRBDebName is Null ("-").

       

      Alternatively, I could only load Rows where ISHRBDebAcc is a number between 1 and 999999...

       

      can anyone advise on this?

       

      Thanks...

       

      Fabrizio Giorgio


       

      Message was edited by: Fabrizio Giorgio