supress blank row coming from excel

[#1]

I have 4 fields 3 fields in my excel file, 3 of them have all values(1 or 0) bt 4th field is having blank other than (1 or 0) ...

so in the front end when I use that field I am getting 3 rows one with blank ,1,0...I tried using supress null on dimension bt not working.....

[shree909]

hi

better u remove the blank field from the excel file  if u dont need at the presentaion

and then reload  that will solve ur problem

or usingfile wizard  tranformation delete the  balnk file..

Thanks;'

[#3]

if I remove those rows in excel, the count of all other 3 fields ll get effected.

Can you explain me file wizard tranformation....