topic Re: Excluding things from a field during load in QlikView

Excluding things from a field during load

Mon, 04 Aug 2014 18:59:14 GMT

Hi, I have a field where I have bunch of things that I don't need. How can I limit this?

For example, I have a field called production_line where I only need things that start with the letter L.

production_line

wsk090

lsk090

lam110

man102

so I only want to extract the 'lsk090' and 'lam110'

Re: Excluding things from a field during load

jerem1234 — Mon, 04 Aug 2014 19:03:45 GMT

Try somethng like:

Table2:

Load .....

Resident Table1

where production_line like 'l*';

Hope this helps!

Re: Excluding things from a field during load

ecolomer — Mon, 04 Aug 2014 19:05:40 GMT

In the select you can put ...

where left(production_line, 1)='l';

to select only the elements from production_line with first leter = l

Saludos,

Enrique

Re: Excluding things from a field during load

Mon, 04 Aug 2014 19:46:17 GMT

Right now, I'm using a QVD to load this field.

Would I put Where Left(production_line, 1)='1' right after the field in the load statement?

Re: Excluding things from a field during load

jerem1234 — Mon, 04 Aug 2014 19:59:30 GMT

Something like:

Data:

LOAD *

FROM Test.qvd (qvd)

where production_line like 'l*';

So, yes after load statement.

Re: Excluding things from a field during load

Mon, 04 Aug 2014 20:00:48 GMT

Hi,

Yes use Left() function but change = '1' for = 'l' (L) or use commodin "*" something like this:

* Opc1 (Left)

Table1:

LOAD *

From myFile.qvd

Where Left(production_line,1)='l';

* Opc2 (Commodin *)

Table1:

LOAD *

From myFile.qvd

Where production_line,1 like 'l*';

Best regards.

Re: Excluding things from a field during load

maxgro — Mon, 04 Aug 2014 20:11:03 GMT

after from

load

... // your fields

from

somefile.qvd (qvd) // your qvd

where

Left(production_line, 1)='l' // or production_line like 'l*' as Jeremiah suggested

;

Re: Excluding things from a field during load

ecolomer — Mon, 04 Aug 2014 20:16:58 GMT

Yes,

LOAD * from file.qvd

where left(production_line, 1)='l';

where production_line like 'l*';

Saludos,

Enrique

Re: Excluding things from a field during load

Mon, 04 Aug 2014 22:08:30 GMT

It is not working for some odd reason. Right now I have this,

Load

field1

field2

resource

field3

from example.qvd (qvd)

where left(resource,1)='l*'

and it is not fetching any lines from this table. It says '0 lines fetched'

Re: Excluding things from a field during load

maxgro — Mon, 04 Aug 2014 22:11:17 GMT

where left(production_line, 1)='l';

Re: Excluding things from a field during load

Tue, 05 Aug 2014 13:31:26 GMT

i am think you are not following mr qlikview beginner:

try this:

left(production_line, = 'L' or 'l') where 1;

your friend - KILGORE WATTS

Re: Excluding things from a field during load

Tue, 05 Aug 2014 16:25:38 GMT

hello qlikview beginer,

please give my answer considration it is due and give helpful. thanks

your friend - KILGORE WATTS

Re: Excluding things from a field during load

Tue, 05 Aug 2014 17:02:10 GMT

Thank you Kilgore. I tried your response and it was giving me an error for some odd reason. The answer from Massimo from above has helped with this.

Re: Excluding things from a field during load

Tue, 05 Aug 2014 17:06:24 GMT

i see how is

your friend - KILGORE WATTS