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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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;