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.

Concat in IDT


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
ash0550
Principal Member
Principal Member



Joined: 12 Sep 2011

Posts: 273


flag
PostPosted: Wed May 20, 2020 11:32 am 
Post subject: Concat in IDT

Hi,
I have an issue with Concat field in IDT and I am unable to resolve it

I have Firstname, middle and lastname and I am using concat function in IDT but when i drag it into webi i donot see any results, it is just blank

Now if i instead use by FN,MN and last name in a varaible in Webi I can see the results

any idea why this is happening

below is the concatination i am using in IDT

{fn
concat(client_name.client_first_name, concat(' ',
concat(client_name.client_middle_name,concat(' ',
client_name.client_last_name))))}
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  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.0264 seconds using 17 queries. (SQL 0.0022 Parse 0.0008 Other 0.0233)
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