topic Re: Load qvd file with filtered values in QlikView

Load qvd file with filtered values

shani — Sat, 16 Nov 2024 05:03:43 GMT

Hi,

I have a data where i need to load a filtered values , the file has more than 1 million rows.

The file have values in this format

1234

12345

1234-123-12

12335-123-12

i want to import all values with this format 1234-123-12 and 12345-123-12

How do i do that?

Re: Load qvd file with filtered values

sunny_talwar — Tue, 04 Dec 2018 16:13:52 GMT

May be like this

LOAD ...,
FROM ....
Where SubStringCount(FieldName, '-') = 2;

Re: Load qvd file with filtered values

Colin-Albert — Tue, 04 Dec 2018 18:07:01 GMT

This looks for data with the format xxxxx-xxx-xx or xxxx-xxx-xx
If the number of characters doesn't matter then you can use  wildmatch(FieldName, '*-*-*') > 0



LOAD ..., 
FROM .... 
Where wildmatch(FieldName, '?????-???-??') > 0 or wildmatch(FieldName, '????-???-??') > 0;

Re: Load qvd file with filtered values

shani — Tue, 04 Dec 2018 21:56:42 GMT

this statement fixed the issue

where wildmatch(fieldname, '*-*-*') > 0;

Thanks alot for help.