10 Replies Latest reply: Sep 8, 2014 1:34 PM by Vlad Gutkovsky RSS

    IF(OR(function in Load script

      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 BusinessManufacturerEntityGBU Product TargetProduct Sub-ClassManufacturer TypeStandard Cost SourceQuantityPROJECT SCOPE
      OTHERADJ147GRANT REVENUEADJUSTMENTSUNKNOWNNOT APPLICABLE1EXCLUDED
      SERVICESI118120INFECTIOUS DISEASEOTHERALERENOT APPLICABLE2EXCLUDED
      OTHERADJ10GRANT REVENUEADJUSTMENTSUNKNOWNNOT APPLICABLE1EXCLUDED
      OTHERNOT73ROYALTIESOTHERNOT RELEVANTNOT APPLICABLE0EXCLUDED
      PRODUCTSI02231MALARIADIAGNOSTIC TESTALERETRANSFER PRICE2EXCLUDED
      PRODUCTSI02221MALARIAANTIBODY/ENZYME/REAGENTALERENOT APPLICABLE3EXCLUDED
      PRODUCTSI05624HIVDIAGNOSTIC TESTALERENOT APPLICABLE0INCLUDED

       

      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!