I have a scenario, like i have a million records of data.this is sample data...
DEPT | city | two_mail | Dept_Disc | |
---|---|---|---|---|
Human Resource | del | ddd.dev@xyzcomp.com | 0 | 0 |
Infrastructure | mum | frv.xxt@xyzcomp.com | 1 | 0 |
Human Resource | nav | xini.abbas@xyzcomp.com | 0 | 0 |
Infrastructure | pun | busu.lal@xyzcomp.com | 0 | 0 |
Human Resources | bang | tink.lal@xyzcomp.com | 0 | 1 |
Infrastructure | chen | frv.xxt@yahoo.com | 0 | 0 |
Human Resource | triv | ratr.ali@xyzcomp.com | 0 | 0 |
Infrastructure | vish | sritu.singh@xyzcomp.com | 0 | 0 |
i want to check if there is any misspelled in DEPT column for eg(Human Resources)
also if person has given a general mail id in, so for that name i want to check if we have any corporate mail id of that particular person
for example frv.xxt@yahoo.com has given personal mail id now i want to check if we have any corporate mail_ID for the same frv.xxt person
frv.xxt = frv is first name and xxt is last name.
the output i am requiring is