Solved

Concatenate Column and String

  • 13 March 2022
  • 3 replies
  • 163 views

Hello,

Can we create a custom column where we concatenate a column and a string? how do we do it? 

icon

Best answer by Moises Morales 14 March 2022, 09:49

View original

3 replies

Userlevel 3

Hi Jeny, 

 Could you please provide a visual example of what you are trying to achieve or a small explanation of your use case? 

Thanks.

 

-Moises

for example we have this two columns:
First Name and Last Name


How do we create a column Full Name, which is First Name + space + Last Name?
And then, what if I wanted a String: “Customer” on the beginning, just for example of String and Column concatenation

the desired outcome should be
“Customer Aaron Ng​”​​​​​​

Userlevel 3

I understand the use case now. Unfortunately, you cannot really merge/concatenate two attributes into a new attribute within our Platform. Currently you are able to add the "First name"/"Last Name" attribute to your report, so it can show on your insight. If you wish to have this data under one same attribute, you willl have to modify your dataset from your source data. 

I hope it makes sense, but please let me know if there is anything unclear.

Reply