topic Re: Devide a key in QlikView

Devide a key

Anonymous — Fri, 16 Sep 2016 11:54:04 GMT

Hi all,

i build a "key" like ABC34_2324_234234234.

Now I want to devide it like:

ABC34

2324

234234234

I did this with left(key, 5) as Key 1

etc.

I wanted to ask if it is possible to devide by using "_" so that the lenght of each key doesn't matter.

Thank you fpr helping!

Re: Devide a key

m_woolf — Fri, 16 Sep 2016 11:57:05 GMT

subfield(Key,'_',1) as Key1,

subfield(Key,'_',2) as Key2,

subfield(Key,'_',3) as Key2,

Re: Devide a key

trdandamudi — Fri, 16 Sep 2016 11:57:15 GMT

Try to use Subfield...

Re: Devide a key

stigchel — Fri, 16 Sep 2016 11:57:48 GMT

You can use the function SubField() e.g.

SubField(Key,'_',1)

SubField(Key,'_',2)

SubField(Key,'_',3)

Re: Devide a key

MindaugasBacius — Fri, 16 Sep 2016 11:58:39 GMT

Take a look to Subfield function:

SubField ‒ QlikView

Re: Devide a key

Chanty4u — Fri, 16 Sep 2016 12:02:36 GMT

try below

LOAD * INLINE [

Data

ABC34_2324_234234234

];

Result:

LOAD *,

SubField(Data,'_') as key

Resident a;

Re: Devide a key

Fri, 16 Sep 2016 12:02:51 GMT

Hi,

Try using the SubField function. Something like this:

Key1 = SubField( key,'_')

Something I just learned recently.

With this function you can even pull out the next field as in:

Key2 = SubField( key,'_',2)

Hope this is what you need!

- Stan