CONCAT USING CONDITION

Question & Answer
, ,
1

I have one dataset, and the dataset has two fields: createdby_userid and updatedby_userid , both referring to the same userId. Essentially, they are identical.

userId firstName lastName
001 kael cena
002 sharon roger
003 jack william
004 wan wish

However, I want to display the concat(firstName, ’ ', lastName) from updatedby_userid on my visual. Instead of meeting my requirement, it displays the concat(firstName, ’ ', lastName) from createdby_userid

Can someone help me how to show updatedby_userid concat(firstName, ’ ', lastName)?

2

Hi @hisyamdarwis
if they are identical why is there a difference?
Createdid and updatedid are also a column in the dataset?
BR

3

Let say concat(firstName, ’ ', lastName) = fullName calculated field,

The problem is i want to return only for updatedby_userid fullName, but it will display the createdby_userid fullName. Examples

createdby_userId fullName updateby_userid fullName
001 kael cena 002 sharon roger

But my table return like this

createdby_userId fullName updateby_userid fullName
001 kael cena 002 kael cena

Instead of return fullName for userid 002, it return fullName for 001.

4

Is your database/dataset? If so, I would suggest to rename the fullname into fullname_createdby and fullname_updatedby.

5

Hi @hisyamdarwis
any updates on your side?
BR

6

I use updatedby_userid as filter for display fullName, its working!

Thanks @ErikG