Chek for duplicate entries

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Chek for duplicate entries

Viewing 0 reply threads
  • Author
    Posts
    • August 3, 2009 at 12:43 AM #22940
      community-content

         hi

        I want to check for the duplicate entries on basis of email address coming form csv file. iwant to know how to check for it the file may contain empty fields also i am  updating status column based on data given.

        <ns0:Employee xmlns:ns0=”http://PrimaryFile.EmployeeDocument“>

        – <Employee>
          <Org_Code>31-29-00-0000-00</Org_Code>
          <FIRST_NAME>Sam</FIRST_NAME>
          <LAST-NAME />
          <MI>M</MI>
          <TITLE>PUBLIC AFF SPECLST(REGIONAL COMM DIR)</TITLE>
          <PP>GS</PP>
          <Series>1032</Series>
          <GR>12</GR>
          <Step>1</Step>
          <PD>A0212001</PD>
          <User_Role>1</User_Role>
          <Email_Adress>abc.com</Email_Adress>
          <PrimarySupervisor>[email protected]</PrimarySupervisor>
          <SecondarySupervisor>[email protected]</SecondarySupervisor>
          <Status><BR>Orgcode is not given</BR> <BR>Invalid email passed</BR></Status>
          </Employee>
        – <Employee>
          <Org_Code>31-29-00-0000-00</Org_Code>
          <FIRST_NAME>Rutu3221vdfbdfgdggggghsdfsdf</FIRST_NAME>
          <LAST-NAME>qqe122</LAST-NAME>
          <MI>t</MI>
          <TITLE>PUBLIC AFF T(REGIONAL COMM DIR)</TITLE>
          <PP>GS</PP>
          <Series>1032</Series>
          <GR>12</GR>
          <Step>1</Step>
          <PD>A0212001</PD>
          <User_Role>1</User_Role>
          <Email_Adress>[email protected]</Email_Adress>
          <PrimarySupervisor>[email protected]</PrimarySupervisor>
          <SecondarySupervisor>[email protected]</SecondarySupervisor>
          <Status><BR>First Name is very large</BR> <BR>Last Name is very large</BR> <BR>Invalid email passed</BR></Status>
          </Employee>
        – <Employee>
          <Org_Code />
          <FIRST_NAME />
          <LAST-NAME />
          <MI />
          <TITLE />
          <PP />
          <Series />
          <GR />
          <Step />
          <PD />
          <User_Role />
          <Email_Adress />
          <PrimarySupervisor />
          <SecondarySupervisor />
          <Status><BR>First Name is not passed</BR> <BR>Orgcode is not given</BR> <BR>Last Name is not passed </BR> <BR>Email id is not passed</BR></Status>
          </Employee>
        – <Employee>
          <Org_Code>31-29-00-0000-00</Org_Code>
          <FIRST_NAME>Sam</FIRST_NAME>
          <LAST-NAME />
          <MI>M</MI>
          <TITLE>PUBLIC AFF SPECLST(REGIONAL COMM DIR)</TITLE>
          <PP>GS</PP>
          <Series>1032</Series>
          <GR>12</GR>
          <Step>1</Step>
          <PD>A0212001</PD>
          <User_Role>1</User_Role>
          <Email_Adress>[email protected]</Email_Adress>
          <PrimarySupervisor>[email protected]</PrimarySupervisor>
          <SecondarySupervisor>[email protected]</SecondarySupervisor>
          <Status><BR>Orgcode is not given</BR> <BR>Invalid email passed</BR></Status>
          </Employee>
          </ns0:Employee>
    • Author
      Posts
    Viewing 0 reply threads
    • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.