Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Tryin to load this statement in load scripts...
if (Group=='B009') {'CONSOLIDATED INSURERS'} else if (Group=='T107') {'THE CONTINENTAL GROUP'} else {Account_Name}
Try following:
if (Group=='B009','CONSOLIDATED INSURERS',if (Group=='T107', 'THE CONTINENTAL GROUP', 'Account_Name')) as Name
Hello Tom,
Try this:
IF(Group=B009,[CONSOLIDATED INSURERS], if (Group=T107 ,['THE CONTINENTAL GROUP] , [Account_Name]))
Regards
Jacek
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
Did you get what you looking for?
Yes I did...Thank you very much
Can you close the thread marking appropriate responses as correct or Helpful.
Thanks
V.
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