topic Re: Using subfield with multiple selections in QlikView

Using subfield with multiple selections

joey_lutes — Mon, 29 Jan 2018 21:52:57 GMT

I'm trying to do what I think might be a simple thing, though I might be going at it wrong.

I have a piece of data (which happens to be a filename, but not too important)

it's in format:

Word-Thing-Idea-Number-Description-Iteration

What I want is to parse out the first 4 subfields and call that 'id', ending up with:

Word-Thing-Idea-Number only.

The lengths are different, so left() won't work.

subfield() seems to be producing strange results when I try different things.

Any way besides splitting it out individually and then re-concatenating it?

thanks in advance.

Re: Using subfield with multiple selections

Anil_Babu_Samineni — Tue, 30 Jan 2018 00:29:35 GMT

That means, You are going to get first 4 words from Field?

Re: Using subfield with multiple selections

Siva_Sankar — Tue, 30 Jan 2018 01:25:40 GMT

Hi Joey,

Subfield should work. Can you post or upload an example or your requirement in a qvw file?

Some examples for you How to Split the string into number of sub strings and how to extract date from filename

-Siva

Re: Using subfield with multiple selections

joey_lutes — Wed, 31 Jan 2018 19:15:22 GMT

First off, this is Qlik Sense, so qvw isn't an option.

Here's an example:

Data:

LOAD * INLINE [

id, data

1, ab-cde-efgh-ij-k-lm

2, abc-de-fg-hij-klm

];

NewData:

Load

id,

subfield(data, {fields1-4??}) as newdatafield

Resident Data;

Ideal end result:

id, newdatafield

1 ab-cde-efgh-ij

2 abc-de-fg-hij

Thanks

Re: Using subfield with multiple selections

vishsaggi — Wed, 31 Jan 2018 22:11:09 GMT

May be try this?

LOAD *, LEFT(data, Index(data, '-',4)-1) AS NewDatafield INLINE [

id, data

1, ab-cde-efgh-ij-k-lm

2, abc-de-fg-hij-klm

];