BusinessObjects Board

Concat in IDT

building semantic layer
#1

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))))}

ash0550 :canada: (BOB member since 2011-09-12)

#2

I always do a check for a null middle name. A lot of times there is no middle name and thus it makes the whole string null.

kevlray :us: (BOB member since 2010-06-23)