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

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

Adding text to values

Hi,

I have a set of values i'm importing to QlikView. For this example, the column will be 'Name' and will look like this:

Name

John

Peter

Simon

etc...

When loading the script, how can I add the surname 'Smith' to each of these without disrupting the source data? I want the result to look like this

Name

John Smith

Peter Smith

Simon Smith.

Thanks!

3 Replies
Not applicable
Author

You can load your table, do a resident load and concatenate the Firstname with Smith.

I tried this using Inline load ...see below

 

Names:

Load * Inline [
Name
John,
Peter,
Simon
]
;

WithLastNames:
Load
Name &' Smith' As FullName
resident Names;

drop table Names;

Output is

John Smith

Peter Smith

Simon Smith

maxgro
MVP
MVP

& is the operator for string concatenation

you can use & in script and in chart expression too

its_anandrjs
Champion III
Champion III

You can do like in the script

Load

Name,

Name&'Smith' as Name&Surname  // Add this field in your load statements

From Location;