Hi,
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!!!!!
Thanks a lot!
