topic Re: Display Matched String Values Only in QlikView

Display Matched String Values Only

Tue, 10 Feb 2015 11:49:47 GMT

Hi,

In my Table i have a field with String value in that some are started with Like ABCD.

i need only which Starts with ABCD Only.

now i want to filter the data while load in to the Qlikview.

Means

Cloumn1
ABCD_XYZ
ABCD_MNO
ABCD_EFG
ABCD_LMN
ABCD_PQR

I NEED ONLY LIKE THIS IN MY DATA HOW CAN I DO THIS. PLEASE HELP ME

Re: Display Matched String Values Only

tresB — Tue, 10 Feb 2015 11:54:35 GMT

Load

YourStringField

From <> Where WildMatch(YourStringField, 'ABCD*');

Re: Display Matched String Values Only

rubenmarin — Tue, 10 Feb 2015 11:56:45 GMT

Hi, while loading in QV you can filter that data adding a where clause:

LOAD ....

FROM ...

Where Left(FieldName, 4)='ABCD';

or if it's SQL:

LOAD...;

SELECT...

WHERE FieldName='ABCD%'

or:

LOAD...;

SELECT...

WHERE Left(FieldName, 4)='ABCD'

Re: Display Matched String Values Only

robert_mika — Tue, 10 Feb 2015 12:13:20 GMT

LOAD if(left(Code,4)='ABCD',Code)

FROM

[151434.xlsx]

(ooxml, embedded labels, table is Sheet1);

Re: Display Matched String Values Only

Tue, 10 Feb 2015 12:22:50 GMT

Thank You Robert,

It is working.

Re: Display Matched String Values Only

robert_mika — Tue, 10 Feb 2015 12:23:51 GMT

Your are welcome

Re: Display Matched String Values Only

Michiel_QV_Fan — Tue, 10 Feb 2015 12:26:36 GMT

Load_limiter:

LOAD * INLINE [

load_limiter

ABCD

];

table:

load *,

left(field1, 4) as limit;

LOAD * INLINE [

field1, field2

ABCD_123, 1

ABCD_456, 2

ACDB_123, 3

];

table2:

NoConcatenate

Load

Resident table

where Exists (load_limiter,limit);

drop table table;

drop table Load_limiter;