8 Replies Latest reply: Jul 29, 2016 12:40 PM by Mario Ma RSS

    Replace Null to 'NA' in Jone'ed Load

    Mario Ma

      Hi,

      I  have data load like below :

      [Detals]:

      LOAD

         Dept,

         Sub    as [CatID]

      from [lib://myfile.xlsx];

      left join            //------------------

      [MapCat]:

      LOAD

          //CategoryName as Category,

          if(IsNUll(CategoryName), 'Other', CategoryName) as Category,

          text(Sub)  as [CatID]

      FROM [lib://mymapfile.xlsx];

       

      My goal to have all missing Category = 'Other' , I tried this syntax but it didn't work, I feel that that LOAD works bit differently then SQL join.

      and I want to keep my left join in place. Is there the way to achive this in Q?

       

      CatID      Category

      11          Alpha

      22          Bravo

      3333        Other**??

       

      Thanks

      M