Display Matched String Values Only

[#1]

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

[tresesco]

Load

          YourStringField

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

[rubenmarin]

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'

[robert_mika · Accepted solution]

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

FROM

[151434.xlsx]

(ooxml, embedded labels, table is Sheet1);

[#5]

Thank You Robert,

It is working.

[robert_mika]

Your are welcome

[Michiel_QV_Fan]

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;