Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to add prefix and suffix?

Suppose I have data as follows,
Emp_name|Emp_Id|Emp_dept
Leonardo DiCaprio|1000|Finance
Cristian Bale|1004|Security
Jennifer Lawrence|1002|HR
Morgan Freeman|1006|Admin
Now say I want to add, prefix 'Dr. ' to every entry under column name Emp_name. For example, data in output should be something as follows,
Dr. Leonardo DiCaprio|1000|Finance
Dr. Cristian Bale|1004|Security
Dr. Jennifer Lawrence|1002|HR
Dr. Morgan Freeman|1006|Admin
Or maybe I want to add, suffix 'ABC' to every entry under column name Emp_Id. For example, data in output should be something as follows,
Leonardo DiCaprio|1000ABC|Finance
Cristian Bale|1004ABC|Security
Jennifer Lawrence|1002ABC|HR
Morgan Freeman|1006ABC|Admin
Labels (2)
3 Replies
Anonymous
Not applicable
Author

Hi,
tMap component can meet your needs.
Best regards
Sabrina
0683p000009MCxz.png
Anonymous
Not applicable
Author

Hi, Xdshi.. thanks for your help... it works. What I wanted to know is that you have marked the data type section to show that this logic works on string only... right? Or you want to show that data types on both sides should be matching.
Anonymous
Not applicable
Author

Hi,
The "String" type can add string(prefix and suffix 0683p000009M9p6.pngtring s=string1+string2) directly with "+". This logic works on string only.
Best regards
Sabrina