if statement in load script

[#1]

Hi,

what is not correct ?

LOAD
Hierarchy,
NetValue,
if((BP-Account= 'Corporate'), 1), if((BP-Account= 'Key'), 2),
if((BP-Account= 'Standard'), 3), if((BP-Account= 'Private'), 4)
as CorpAccGrID
from data

Thanks

[#2]

Else part missing from your expression

[#3]

Try this

if

((BP-Account= 'Corporate'), 1, if((BP-Account= 'Key'), 2,if((BP-Account= 'Standard'), 3, if((BP-Account= 'Private'), 4

))))

as

CorpAccGrID

[#4]

Hi,

Thanks

you mean

LOAD
Hierarchy,
NetValue,
if((BP-Account= 'Corporate'), 1) else if((BP-Account= 'Key'), 2) else
if((BP-Account= 'Standard'), 3) else if((BP-Account= 'Private'), 4)
as CorpAccGrID
from data

[Anonymous]

Try like this

If([BP-Account]='Corporate',1,
 If([BP-Account]='Key',2,
 If([BP-Account]='Standard',3,
 If([BP-Account]='Private',4)))) as CorpAccGrID

In all other cases CorpAccGrID will be Null.

Rgds,
Artjoms

[Anonymous]

else part is optional in If statement

Rgds,
Artjoms

[#7 · Accepted solution]

Hi,

Thanks for all help .

That works.