Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - i need to remove several business units from the data when loading
However script isn't working
FACT:
LOAD Date(TR_Date) as TRDate,
"Item_Number",
"Item_Desc",
"Business_Unit",
Quantity,
"Doc_Type",
UOM,
"Usage_Var",
"Theoretical_Usage",
Adjustments,
(Usage_Var + Theoretical_Usage + Adjustments) as Actual_Usage
Where Business_Unit <> '1832105' or '1611102'
;
SQL SELECT *
FROM "OPI_DATAMART".dbo."F_DATA_Asphalt_Usage_RCI"
What have i done wrong !!!
thx in advance
;
Try
Where Business_Unit <> '1832105' and Business_Unit <> '1611102';
or
where not match(Business_Unit, '1832105','1611102');
Try
Where Business_Unit <> '1832105' and Business_Unit <> '1611102';
or
where not match(Business_Unit, '1832105','1611102');
thanks - newbie with qv syntax - helped me a lot
thanks - newbie with qv syntax - helped me a lot
thx - that helped a lot - i'm a newbie with QV syntax