Load Script If statement causes ODBC error...?

Fri, 15 Jul 2011 13:15:38 GMT

Hi everyone,

Would anyone be able to offer a reason or solution to how an If statement causes an ODBC error.

............

,if(NOT(ISNULL(MedicalComplaint)) AND NOT(ISNULL(TraumaComplaint)),MedicalComplaint & ',' & TraumaComplaint,

if(ISNULL(MedicalComplaint) AND NOT(ISNULL(TraumaComplaint)),TraumaComplaint,

if(NOT(ISNULL(MedicalComplaint)) AND ISNULL(TraumaComplaint),MedicalComplaint))) as ChiefComplaint

However this one works, the only difference being the last line is ommitted.

..........

,if(NOT(ISNULL(MedicalComplaint)) AND NOT(ISNULL(TraumaComplaint)),MedicalComplaint & ',' & TraumaComplaint,

if(ISNULL(MedicalComplaint) AND NOT(ISNULL(TraumaComplaint)),TraumaComplaint)) as ChiefComplaint

Many thanks in advance

danielrozental — Fri, 15 Jul 2011 18:53:15 GMT

Try posting the entire sentence. What vendor database are you trying? SQL Server?

topic Load Script If statement causes ODBC error...? in QlikView