3 Replies Latest reply: Jun 25, 2012 5:22 PM by Jonathan Love RSS

    Flag multiples of an item at location/item

    Jonathan Love

      Hi, The Left Join Load below sets a flag in the script (Flag_Possible_Dupe)  when a unique SVMXC_IP_Sibex_Name exists more than once at a SVMXC_IP_Site_Id_Key.    I am struggling to now set another flag where there is more than one SVMXC_IP_Parent_Id_Key per SVMXC_IP_Sibex_Name at a SVMXC_IP_Site_Id_Key.  Any thoughts?  SVMXC_IP:  LOAD SVMXC_IP_Site_Id_Key, SVMXC_IP_Sibex_Name, SVMXC_IP_Parent_Id_Key  FROM \\xxx (qvd)   Left Join Load SVMXC_IP_Site_Id_Key, SVMXC_IP_Sibex_Name, if(count(SVMXC_IP_Sibex_Name)>1,1,0) as Flag_Possible_Dupe Resident SVMXC_IP group by SVMXC_IP_Site_Id_Key, SVMXC_IP_Sibex_Name;

        • Re: Flag multiples of an item at location/item
          Jonathan Love

          I do not know why my formatting in this forum always chnages after I hit the submit button...

           

          SVMXC_IP:

          LOAD

          SVMXC_IP_Site_Id_Key,

          SVMXC_IP_Sibex_Name,

          SVMXC_IP_Parent_Id_Key,

          FROM ...qvd

           

          LEFT JOIN LOAD

          SVMXC_IP_Site_Id_Key,

          SVMXC_IP_Sibex_Name'

          if(count(SVMXC_IP_Sibex_NAme)>1,1,0) as Flag Possible_Dupe

          Resident SVMXC_IP group by SVMXC_IP_Site_Id_Key,

          SVMXC_IP_Sibex_Name;

           

          Works fine to set a flag when a unique SVMXC_IP_Sibex_Name exists more than once at a SVMXC_IP_Site_Id_Key, but I would like to add anothe left join load that flags

          when more than one SVMXC_IP_Parent_Id_Key exist per SVMXC_IP_Sibex_Name at SVMXC_IP_Site_Id_Key.