topic Using if within the Load statement in QlikView

Using if within the Load statement

Tue, 02 Feb 2010 23:14:24 GMT

I have a data field [PHONE] that contains phone numbers and e-mails. I need to format the phone # during the load and I was trying to use the following:

LOAD
..

if (FindOneOf(PHONE, '@') > 0,
// e-mail

(PHONE as [Main Contact]),

// Phone Number or FAX
('+1 (' & Left(PHONE, 3) & ') ' & Mid(PHONE, 4, 3) & '-' & Right(PHONE, 4) as [Main Contact])),

......

FROM

.....

QV displays the error: "Error in expression: ')' expected" and I am not sure why.

I would appreciate an expert advice.

Regards,

Using if within the Load statement

vgutkovsky — Tue, 02 Feb 2010 23:24:28 GMT

Hi, Vladimir.

Does this work?

if (FindOneOf(PHONE, '@') > 0, PHONE, ('+1 (' & Left(PHONE, 3) & ') ' & Mid(PHONE, 4, 3) & '-' & Right(PHONE, 4))) as [Main Contact],

Using if within the Load statement

prieper — Tue, 02 Feb 2010 23:26:14 GMT

I think that the last bracket is too much, moreover you do not need to bracket the two IF-condition, thus think that

LOAD
 ..
 // if (FindOneOf(PHONE, '@') > 0,
 // e-mail
 PHONE as [Main Contact],
 // Phone Number or FAX
 '+1 (' & Left(PHONE, 3) & ') ' & Mid(PHONE, 4, 3) & '-' & Right(PHONE, 4) as [Main Contact]),
 ......
FROM .....

Peter

Using if within the Load statement

Tue, 02 Feb 2010 23:49:21 GMT

Yes, it works. Thank you!

Using if within the Load statement

Tue, 02 Feb 2010 23:50:24 GMT

Thank you, Peter.