7 Replies Latest reply: Jan 16, 2014 7:46 AM by Mambi Badi RSS

    empty cells

    Mambi Badi

      hi everyone,

      i have a table with many columns containing empty cells (with null value)  as in the example below :

       

      categoriesfield1
      category 1sport
      category 2music
      category 3travel
      category 4
      category 5games
      category 6
      category 7books

       

      for the column field1  i want to keep the blank cells after the loading script 

      i can get the result by using : if(isnull(fields),'',fields) as col in the load script but i have many columns  so i don't want to the this test for over 10 fields , is there any way do this automatically (like verbatim for spaces)

       

      thanks