topic Re: Reordering a string in load in QlikView

Reordering a string in load

Wed, 07 May 2014 08:18:10 GMT

Hi all,

I have some data that's ordered: "lastname * firstname * age".

id like to load the column so it just displays "firstname lastname".

Is this possible? Thanks!

Wed, 07 May 2014 08:20:51 GMT

load subfield(<column>,'*',2) & ' ' & subfield(<column>,"*',1) as newname

richard_pearce6 — Wed, 07 May 2014 08:26:09 GMT

You can do that using string functions

left('[Name]',index('[Name]','*',2)-1) as Name

This reads up to the second space and drops the age

You can put the whole thing into a replace function if you want to drop the middle ' * '

Richard

jsingh71 — Wed, 07 May 2014 08:26:33 GMT

Use this:

SubField('lastname * firstname * age' ,'*',2) & SubField('lastname * firstname * age' ,'*',1) as Name

--Jai

its_anandrjs — Wed, 07 May 2014 09:02:06 GMT

Load new field in the load script

Load

Name,

Right(Trim(Left(Name,index(Name,'*',2)-1)),9)&' '&Trim(Left(Name,index(Name,'*',1)-1)) as NewName

From Location;

preminqlik — Wed, 07 May 2014 09:11:50 GMT

Load *,

subfield(fieldname,'*',-2)&' '&subfield(fieldname,'*',-3) as Name

from path;