remove 0 values row from table box

[capriconuser]

i have this script

Directory;

LOAD head,

     subhead,

     IsNull(amount) = 0 as amount,

     IsNull(month) = 0 as month

FROM

test.xlsx

(ooxml, embedded labels, table is Sheet2);

this shows like this

now here i want to remove these 0 values data from table beacuse i want when  i export this table i dont want to these 0 values row data in excel

here i add last line through button .. on button i choose dynamic updated and write insert query so when i fill text boxes and click on add then record has been added  and first two rows is coming from script beacuse test.xlsx is like this

head	subhead	amount	month
abc	abc1
def	def1

how i do this

i try to export from actions--external--export

[Chanty4u]

you can try this

num(PurgeChar(Replace(Ltrim(replace(Month,0,' ')),' ',0),'+')) as Month1;

num(PurgeChar(Replace(Ltrim(replace(Amount,0,' ')),' ',0),'+')) as Amount1;

[MK_QSL]

In stead of Table box, use straight table

[capriconuser]

i am using straight table and in straight table data looks fine but when i export the table value with 0 rows are also applied in excel sheet where as i dont want this in excel sheet

[capriconuser]

in script?

[Chanty4u]

yes in script.