if, if else statement for load scripts

[Anonymous]

Tryin to load this statement in load scripts...

if (Group=='B009') {'CONSOLIDATED INSURERS'} else if (Group=='T107') {'THE CONTINENTAL GROUP'} else {Account_Name}

[#2]

Try following:

if (Group=='B009','CONSOLIDATED INSURERS',if (Group=='T107', 'THE CONTINENTAL GROUP', 'Account_Name')) as Name

[Anonymous]

Hello Tom,

Try this:

IF(Group=B009,[CONSOLIDATED INSURERS], if (Group=T107 ,['THE CONTINENTAL GROUP] , [Account_Name]))

Regards

Jacek

[vishsaggi]

Using Jacek expression may be use quotes around the Group values like

if (Group = 'B009', 'CONSOLIDATED INSURERS',

if (Group = 'T107', 'THE CONTINENTAL GROUP', 'Account_Name')) as Name

[vishsaggi]

Did you get what you looking for?

[Anonymous]

Yes I did...Thank you very much

[vishsaggi]

Can you close the thread marking appropriate responses as correct or Helpful.

Thanks
V.

[omkarvamsi]

Hi,

please try below script

if (Group='B009', 'CONSOLIDATED INSURERS',

     if (Group='T107','THE CONTINENTAL GROUP','Account_Name') as ALIASNAME

Note:

if Account_Name is a field it should not be enclosed in the single quotations.

Only strings are to be placed in between in singular quotations.

Regards

Om