topic Re: Adding text to values in QlikView

Adding text to values

Thu, 24 Apr 2014 16:48:47 GMT

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!

Thu, 24 Apr 2014 17:01:43 GMT

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 — Thu, 24 Apr 2014 17:09:22 GMT

& is the operator for string concatenation

you can use & in script and in chart expression too

its_anandrjs — Thu, 24 Apr 2014 17:24:46 GMT

You can do like in the script

Load

Name,

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

From Location;