Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thom_sundberg
Contributor II
Contributor II

LOAD where <> is not working

Hi,

I am trying to LOAD and exclude where "Description = 'Hanteras ej av Inköp'", but I cant get it to work.

What am I doing wrong?

 

Export_upphandling:
LOAD
Procurement_id,
Procurement_number,
Procurement_name,
Procurement_process,
"Userid",
Organisationid,
Estimatedvalue,
Prodgroupid,
Status,
Procurement_created,
Procurement_startdate,
"Procurement_PriorInformationNoticedate (LOU 7:2)",
"Procurement_tendernoticedate (LOU 7:1)",
"Procurement_AssignNoticedate (LOU 9:9)",
"Procurement_AwardNoticedate (LOU 7:3)",
Procurement_tenderduedate,
Agreement_startdate,
Procurement_planned_finishdate,
Procurement_actual_finishdate,
Planned_workhours,
Actual_workhours,
statusno,
Procurement_Process_InternalName,
IsPublic,
"Invited emailreceivers",
IsAppealed,
AppealNote,
LastAppealStartDate,
LastAppealEndDate,
Procurement_description,
if(Estimatedvalue<=10000000,'0-10MSEK',if(Estimatedvalue<=50000000,'10MSEK-50MSEK',if(Estimatedvalue<=250000000,'50MSEK-250MSEK',if(Estimatedvalue<=500000000,'250MSEK-500MSEK','500MSEK+')))) AS TS_EstimatedValue_Kat
FROM [$(path_to_csv)Export_upphandlingar.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq)
where Organisationid='758'
;

left join (Export_upphandling)
Load
Procurement_id,
Description
FROM [$(path_to_qvd)kategorisering.qvd](qvd)
Where Description<>'Hanteras ej av Inköp'
;

 

Lines with "Hanteras ej av Inköp" is still present after the load-script.

Labels (1)
5 Replies
JordyWegman
Partner - Master
Partner - Master

Hi Thom,

Try this:

Left join (Export_upphandling)
Load
   *
;
Load
   Procurement_id,
   Description
FROM [$(path_to_qvd)kategorisering.qvd](qvd)
Where Description <> 'Hanteras ej av Inköp'
;

Jordy

Climber

Work smarter, not harder
thom_sundberg
Contributor II
Contributor II
Author

Hi Jordy,
No luck there.
Is there, by any chance, problems with apps updating with new data?

Because I got this to work:

Export_upphandling:
LOAD
Procurement_id,
Procurement_number,
Procurement_name,
Procurement_process,
"Userid",
Organisationid,
Estimatedvalue,
Prodgroupid,
Status,
Procurement_created,
Procurement_startdate,
"Procurement_PriorInformationNoticedate (LOU 7:2)",
"Procurement_tendernoticedate (LOU 7:1)",
"Procurement_AssignNoticedate (LOU 9:9)",
"Procurement_AwardNoticedate (LOU 7:3)",
Procurement_tenderduedate,
Agreement_startdate,
Procurement_planned_finishdate,
Procurement_actual_finishdate,
Planned_workhours,
Actual_workhours,
statusno,
Procurement_Process_InternalName,
IsPublic,
"Invited emailreceivers",
IsAppealed,
AppealNote,
LastAppealStartDate,
LastAppealEndDate,
Procurement_description,
if(Estimatedvalue<=10000000,'0-10MSEK',if(Estimatedvalue<=50000000,'10MSEK-50MSEK',if(Estimatedvalue<=250000000,'50MSEK-250MSEK',if(Estimatedvalue<=500000000,'250MSEK-500MSEK','500MSEK+')))) AS TS_EstimatedValue_Kat
FROM [$(path_to_csv)Export_upphandlingar.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq)
where Organisationid='758'
;

left join (Export_upphandling)
Load
Procurement_id,
Description1 as huvudkategori,
Description2 as underkategori,
Description3 as underkategori_2,
Description,
Description1

FROM [$(path_to_qvd)kategorisering.qvd](qvd)
Where Description1<>'Hanteras ej av Inköp'
;
JordyWegman
Partner - Master
Partner - Master

Hi Thom,

But did you change anything to the Description? Just renamed it to Description1?

Jordy

Climber

Work smarter, not harder
Vegar
MVP
MVP

Have you checked the output of the load below?

Load
Procurement_id,
Description
FROM [$(path_to_qvd)kategorisering.qvd](qvd)
Where
Description<>'Hanteras ej av Inköp'
;

It could be a miss spelling or initial or tailing blanks? The logical test is case sensitive
You could try:
WHERE trim(LOWER(Description)) <> 'hanteras ej av inköp'
nicu1996
Contributor III
Contributor III

Try:

Load

...

Where not Match(Description, "Hanteras ej av Inköp");