Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
can u upload qvw?
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?
Please see attached. help me
Hi,
Do you have document log of it???
Regards
use
IF(Len(PurgeChar(StageData1,'0123456789'))=0,text(StageData1),StageData1)