topic Re: Exclude values in data load in QlikView

Exclude values in data load

Anonymous — Wed, 22 Jul 2015 12:25:49 GMT

Hi, this is what I currently have in my script and was able to load it fine. From this data load, I'd like to exclude 2 specific values from the Task Name field. Can someone assist -- what do I put and where? Thank you.

TimeTracking:

LOAD [Work Name],

[Work Id],

[Work Type],

[Work Status],

[Task Name],

right([Task Name],len([Task Name])-5) as AdjName,

left([Task Name],5) as QV#,

[Timesheet Remarks]

FROM

[$(vsPath)Timetracking.xlsx]

(ooxml, embedded labels, table is DATA)Where [Work Name]='Application';

Re: Exclude values in data load

Kushal_Chawda — Wed, 22 Jul 2015 12:29:02 GMT

Something like this

TimeTracking:

LOAD [Work Name],

[Work Id],

[Work Type],

[Work Status],

[Task Name],

right([Task Name],len([Task Name])-5) as AdjName,

left([Task Name],5) as QV#,

[Timesheet Remarks]

FROM

[$(vsPath)Timetracking.xlsx]

(ooxml, embedded labels, table is DATA)

Where Where [Work Name]='Application'

and not match([Task Name],'Value1','Value2');

Re: Exclude values in data load

sunny_talwar — Wed, 22 Jul 2015 12:29:19 GMT

Do you want to exclude the complete rows that match those two Task Name or do you want it to be called something else?

Re: Exclude values in data load

ashfaq_haseeb — Wed, 22 Jul 2015 12:29:46 GMT

Try like this

TimeTracking:

LOAD [Work Name],

[Work Id],

[Work Type],

[Work Status],

[Task Name],

right([Task Name],len([Task Name])-5) as AdjName,

left([Task Name],5) as QV#,

[Timesheet Remarks]

FROM

[$(vsPath)Timetracking.xlsx]

(ooxml, embedded labels, table is DATA)Where [Work Name]='Application'

and not match ([Task Name],'Value1','Value2');

Regards

ASHFAQ

Re: Exclude values in data load

Wed, 22 Jul 2015 12:36:37 GMT

Please give excel sheet and mark it which values u want to eliminate

Re: Exclude values in data load

sasiparupudi1 — Wed, 22 Jul 2015 12:56:08 GMT

TBLE1:

LOAD [Work Name],

[Work Id],

[Work Type],

[Work Status],

[Task Name],

right([Task Name],len([Task Name])-5) as AdjName,

left([Task Name],5) as QV#,

[Timesheet Remarks] inline

[

Work Name, Work Id,Work Type,Work Status,Task Name,Timesheet Remarks

Application,1,1,xxx,Task ABC 1,test

Application,2,1,xxx,Task ABC 1,test

Application,3,1,xxx,Task ABC 1,test

Application,4,1,xxx,value1,test

Application,5,1,xxx,Value2,test

Application,6,1,Text1,vaLUe1,test

]

where ([Work Name]='Application' and not (lower([Task Name])=lower('Value1') or lower([Task Name])=lower('Value2')));