topic How to write like clause in load statement? in QlikView

How to write like clause in load statement?

Fri, 07 Jan 2011 13:58:48 GMT

Hi,

I want to refine the data loading in the LOAD statement with help of like clause?

LOAD * from project.qvd (QVD) where project_name like 'projects.%';

Thanks

Samir Sinha

How to write like clause in load statement?

Fri, 07 Jan 2011 14:04:08 GMT

¨Have a look at the wildmatch function, that does exactly what you want.

How to write like clause in load statement?

RickWild64 — Mon, 14 Mar 2011 09:59:03 GMT

You can use 'like':

Load * from project.qvd where project_name like 'projects.*';

should work.

The test is not case-sensitive, so the test above would load 'Projects.xyz' as well as 'projects.xyz'. Wildcards include ? (match a single character) and * (match any number of any characters)

How to write like clause in load statement?

Mon, 14 Mar 2011 10:34:58 GMT

try like this..

LOAD

if( WildMatch(project_name,'projects*') = 1,project_name) as project_name

from project.qvd (QVD);

regards

A'run'

How to write like clause in load statement?

Mon, 14 Mar 2011 10:50:47 GMT

Load * from project.qvd where project_name like 'projects.*';