BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Multiple IfThenElse error


 
Search this topic... | Search DI: Performance and Tuning... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Author Message
niksod
Forum Member
Forum Member



Joined: 16 Feb 2016

Posts: 20



PostPosted: Thu Sep 29, 2016 8:32 am 
Post subject: Multiple IfThenElse error

Im trying to achieve an ifthenelse, help would be much appreciated!

What I want to achieve is the following....in pseudocode, I just need the syntax correct...


ifthenelse
(Street_Trade_Netting.counterpart = 'SS',
Street_Trade_Netting.tradeDate || 'SS' ||
ML_FormatNum(
Street_Trade_Netting.tradeID,
rpad('',10,'0')),

(Street_Trade_Netting.tradeDate || 'KC' ||
ML_FormatNum(
Street_Trade_Netting.tradeID,
rpad('',10,'0'))


EDIT:

I get the following error message when debugging:
8688 11080 VAL-030159 2016-09-29 14:09:31 Found erroneous expression <ifthenelse(Street_Trade_Netting.counterpart= 'SS',


If anyone could help here it would make my day!

Cheers
Back to top
eganjp
Forum Addict
Forum Addict



Joined: 12 Sep 2007
ASUG Icon
Posts: 4280
Location: Denver Area


flag
PostPosted: Thu Sep 29, 2016 12:55 pm 
Post subject: Re: Multiple IfThenElse error

As near as I can tell you're missing one, probably two, right parentheses at the end.
_________________
Jim Egan
ProKarma-an SAP Consulting Partner
Speaker at RMOUG Training Days 2013
Speaker at Sapphire Now 2013
Speaker at Business Objects User Conference 2013
-My ETL is faster than your database! - Advanced ETL performance tuning for Data Services
-Kill ETL bugs before they kill you!
My ETL blog

Latest Blog Posts
• 2014-04-17 Can Your ETL Make Your Reporting Faster?
• 2014-04-04 ProKarma Acquires Mantis Technology Group
• 2014-04-02 How to Create Charts in Webi (Part 2 of 2)
Back to top
bogdanpopey
Forum Member
Forum Member



Joined: 04 Oct 2016

Posts: 2



PostPosted: Tue Oct 04, 2016 9:45 am 
Post subject: Re: Multiple IfThenElse error

i think two icon_wink.gif
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0279 seconds using 18 queries. (SQL 0.0036 Parse 0.0008 Other 0.0235)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo