Struggling with IF statement in LOAD

Thu, 25 Feb 2010 21:44:31 GMT

A schoolboy error i'm sure, but i've checked the syntax and am now well and truly stuck

I'm using an IF statement to load one value for a field if the field is NULL, and another if it is populated. I get an error though saying

Error in expression:
')' expected

Can anyone advise - thanks?

Here's the code.

Extras:

LOAD Chg_ID,
Chg_Desc,
Chg_Just,
([creator_last_name] & ', ' & [creator_first_name]) as CreatorFullName,
([req_last_name] & ', ' & [req_first_name]) as ReqFullName,
IF(ISNULL([owner_last_name]), [owner_last_name] as OwnerFullName ,([owner_last_name] & ', ' & [owner_first_name]) as OwnerFullName]),
([assignee_last_name] & ', ' & [assignee_first_name]) as AssigneeFullName;

SQL SELECT a.id as Chg_ID,a.description as Chg_Desc, a.justification as Chg_Just, b.last_name as creator_last_name,
b.first_name as creator_first_name, c.last_name as req_last_name,
c.first_name as req_first_name, d.last_name as owner_last_name,
d.first_name as owner_first_name, e.last_name as assignee_last_name,
e.first_name as assignee_first_name

FROM
chg a,
ca_contact b,
ca_contact c,
ca_contact d,
ca_contact e

where

a.log_agent *= b.contact_uuid
AND
a.requestor *= c.contact_uuid
AND
a.z_rfc_owner *=d.contact_uuid
AND
a.assignee *=e.contact_uuid;

Struggling with IF statement in LOAD

boorgura — Thu, 25 Feb 2010 22:16:17 GMT

Heym

Do you want to try:

IF(ISNULL([owner_last_name]), [owner_last_name],([owner_last_name] & ', ' & [owner_first_name])) as OwnerFullName,

instead of

IF(ISNULL([owner_last_name]), [owner_last_name] as OwnerFullName ,([owner_last_name] & ', ' & [owner_first_name]) as OwnerFullName]),

Thanks,

Rocky

Struggling with IF statement in LOAD

Thu, 25 Feb 2010 22:36:08 GMT

That works perfectly, thank you!

topic Struggling with IF statement in LOAD in QlikView

Struggling with IF statement in LOAD

Struggling with IF statement in LOAD

Struggling with IF statement in LOAD