topic Re: Separate Values in QlikView

Separate Values

darren_dixon — Thu, 19 Sep 2013 07:19:13 GMT

Hi,

I have a field which contains one or more names and was wondering how I could separate them.

My list box looks like this:

Field: mrASSIGNEES

Andrew

Andrew Ian

Andrew Jon Ian Gary

I'd like my list box to look like this:

Andrew

Gary

Ian

Jon

Thanks,

Darren

Re: Separate Values

tresB — Thu, 19 Sep 2013 07:46:54 GMT

Try SubField() function like:

Subfield(mrASSIGNEES, ' ')

Update: PFA

Re: Separate Values

dmohanty — Thu, 19 Sep 2013 08:00:38 GMT

Hi,

Tresco's solution is very simple and good.

To understand the functionality of Subfield and other functions, you can use this code as well. This wont have the repetive values in the new field.

Name:

load * Inline
[

Name
Andrew
Andrew Ian
Andrew Jon Ian Gary

];

Name1:
load
*,
SubField(Name, ' ',1) as N1,
SubField(Name, ' ',2) as N2,
SubField(Name, ' ',4) as N3

Resident Name;

drop Table Name;

Newname:

load
N1 as NewName Resident Name1;

Concatenate (Newname)

load
N2 as NewName Resident Name1;

Concatenate (Newname)

load
N3 as NewName Resident Name1;

Regards!!!