error handling

[Anonymous]

hai,

i am having multiple files.some of the files has no data..while i am reloading,it showing error..

my requriement is,if the file has no data means it must be skip dt file n then reload the next file...which function is suit for my requiremnt and how????

thanks in advance.

if u not undrstnd means let me know.

[Anonymous]

what's the error you are getting ?

[MK_QSL]

Use FileSize() function while loading in the load script.

How can I check if a file exists ?

Possible to check file size before load?

Also check ErrorMode variable in load script

[Anonymous]

error in exp ')' expectd.

[MK_QSL]

What is the expression you have used?

[Anonymous]

using if condition i have done.. if(((date=Date(Floor(MonthEnd(date))))or date=$(vMaxDate)),Qty,0) as zmonth_qty

[MK_QSL]

Try this

If(date = Date(Floor(MonthEnd(date))) or date = $(vMaxDate), Qty, 0) as zmonth_qty

or

If(date = Date(Floor(MonthEnd(date))) or date = '$(vMaxDate)', Qty, 0) as zmonth_qty,

[Anonymous]

hai manish..thanks for ur post..but it is not working..

[MK_QSL]

Can you provide your whole script here?

[Anonymous]

Hi Sindhu ja

if(date = Date(Floor(MonthEnd(date))) or date = '$(vMaxDate)',Qty,0) as zmonth_qty

The above expression  should work suggested by Manish .

After working on manish's solution are you still getting the error?(I mean error in exp ')' expectd)

Then check whether  you are getting correct date values for vMaxDate.