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: 
timsaddler
Creator III
Creator III

Syntax question(must be simple answer)

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

;

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try

Where Business_Unit <> '1832105' and Business_Unit <> '1611102';

or

where not match(Business_Unit, '1832105','1611102');

View solution in original post

4 Replies
swuehl
MVP
MVP

Try

Where Business_Unit <> '1832105' and Business_Unit <> '1611102';

or

where not match(Business_Unit, '1832105','1611102');

timsaddler
Creator III
Creator III
Author

thanks - newbie with qv syntax - helped me a lot

timsaddler
Creator III
Creator III
Author

thanks - newbie with qv syntax - helped me a lot

timsaddler
Creator III
Creator III
Author

thx - that helped a lot - i'm a newbie with QV syntax