Skip to Content
0
May 20, 2020 at 04:58 PM

Concat in IDT issue

111 Views

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