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.%';
¨Have a look at the wildmatch function, that does exactly what you want.
You can use 'like':
Load * from project.qvd where project_name like 'projects.*';
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)
try like this..
if( WildMatch(project_name,'projects*') = 1,project_name) as project_name
from project.qvd (QVD);
Retrieving data ...