Adding text to values

[#1]

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!

[#2]

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]

& is the operator for string concatenation

you can use & in script and in chart expression too

[its_anandrjs]

You can do like in the script

Load

Name,

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

From Location;