Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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'
;
Hi Thom,
But did you change anything to the Description? Just renamed it to Description1?
Jordy
Climber
Try:
Load
...
Where not Match(Description, "Hanteras ej av Inköp");