continously showing message 'Execution failed to reload' when reloading?

[#1]

Hi,

I have below script in qvw. when I reload every time it is showing 'Execution failed to reload'.

Data:

LOAD RowNo() as Row,

     ID,

     name,

     address,

     Date(dateofbirth,'DD/MM/YYYY') as dateofbirth,

     Date([Enter Date],'DD/MM/YYYY') as [Enter Date],

     IF(Len(PurgeChar(StageData1,'0123456789'))=0,Evaluate(StageData1),StageData1) as StageData1,

     IF(Len(PurgeChar(StageData2,'0123456789'))=0,Evaluate(StageData2),StageData2) as StageData2,

     Status,

     Date([Status Date], 'DD/MM/YYYY') as [Status Date],

     Passed,

     Failed

FROM

QVD\Data.qvd]

(qvd);

Please can anyone suggest me is there any wrong in above script?

Thanks.

[#2]

Len(PurgeChar(StageData1,'0123456789'))=0,Evaluate(StageData1)

here when StageData1 is empty u r asking to evaluate

i tried evaluating empty field it gave "-"

so i hope loading such kind of data is creating problm but it must not throw any problem theoritically

[#3]

can u upload qvw?

[#4]

Thanks. when I comment RowNo() the script is executing fine. but only some values data is loading into the dateofbirth column and [Enter Date] columns. most of the data is missing in these two columns.

is there any way to set this problem?

[#5]

Please see attached. help me

[PrashantSangle]

Hi,

Do you have document log of it???

Regards

[florentina_doga]

use

IF(Len(PurgeChar(StageData1,'0123456789'))=0,text(StageData1),StageData1)