I need to create a separate column in my load script that I could use to filter out Project data. I have a very heavy data load and will need to create a manual flag in the script. Here is a small piece of my data:
Line of Business
Manufacturer
Entity
GBU Product Target
Product Sub-Class
Manufacturer Type
Standard Cost Source
Quantity
PROJECT SCOPE
OTHER
ADJ
147
GRANT REVENUE
ADJUSTMENTS
UNKNOWN
NOT APPLICABLE
1
EXCLUDED
SERVICES
I118
120
INFECTIOUS DISEASE
OTHER
ALERE
NOT APPLICABLE
2
EXCLUDED
OTHER
ADJ
10
GRANT REVENUE
ADJUSTMENTS
UNKNOWN
NOT APPLICABLE
1
EXCLUDED
OTHER
NOT
73
ROYALTIES
OTHER
NOT RELEVANT
NOT APPLICABLE
0
EXCLUDED
PRODUCTS
I022
31
MALARIA
DIAGNOSTIC TEST
ALERE
TRANSFER PRICE
2
EXCLUDED
PRODUCTS
I022
21
MALARIA
ANTIBODY/ENZYME/REAGENT
ALERE
NOT APPLICABLE
3
EXCLUDED
PRODUCTS
I056
24
HIV
DIAGNOSTIC TEST
ALERE
NOT APPLICABLE
0
INCLUDED
I think I will need two columns here:
Column 1: PROJECT SCOPE with the following logic:
If Line of Business = 'SERVICES" then "EXCLUDED"
if Manufacturer ="I022" then "EXCLUDED"
if Entity = '147" then EXCLUDED
if Manufacturer Type = "UNKNOWN" then "EXCLUDED
if Manufacturer Type = "NOT RELEVANT" then "EXCLUDED
Everything else should be marked as "INCLUDED"
Column2: COST DATA with the following logic
If PROJECT SCOPE = "INCLUDED" and Standard Cost Source ="ICONNECT" then AVAILABLE
elseif Standard Cost Source ="REPACKAGED" then AVAILABLE
elseif Standard Cost Source ="TRANSFER PRICE" then AVAILABLE
when Standard Cost Source is "NOT APPLICABLE" and Product Sub-Class = "SALES BOM" then "AVAILABLE"
when Standard Cost Source is "NOT APPLICABLE" and Product Sub-Class = "ADJUSTMENTS" then "AVAILABLE"
when Standard Cost Source is "NOT APPLICABLE" and Quantity = 0 then "AVAILABLE"
for everything else it should be "UNAVAILABLE"
I really need help with this as soon as possible!!!!!
