ratna1234
asked on
Two Table Data comparision
Table I
==========
SL_NO Phases
========= ========
6066 Phase I
6014 Phase II
6013 Phase III
6017 Phase IV
6016 Phase V
Table II
==========
SL_No CALL_IN_NUMBER
===== ================
1 606628347702
2 60177278738
3 601374244
4 60142444
5 60166621344
6 6066923847874
I am expecting that do a look up of Table II in Table in case pattern matches ex 1 row in table II matches with 1st row of table one hence Column C in table two to be filled with Phase I.
similarly 4th Row in Table II matches with row II in table I.
SL_No CALL_IN_NUMBER Col C
1 606628347702 Phase I
2 60177278738 Phase IV
3 601374244 Phase III
4 60142444 Phase II
5 60166621344 Phase V
6 6066923847874 Phase I
==========
SL_NO Phases
========= ========
6066 Phase I
6014 Phase II
6013 Phase III
6017 Phase IV
6016 Phase V
Table II
==========
SL_No CALL_IN_NUMBER
===== ================
1 606628347702
2 60177278738
3 601374244
4 60142444
5 60166621344
6 6066923847874
I am expecting that do a look up of Table II in Table in case pattern matches ex 1 row in table II matches with 1st row of table one hence Column C in table two to be filled with Phase I.
similarly 4th Row in Table II matches with row II in table I.
SL_No CALL_IN_NUMBER Col C
1 606628347702 Phase I
2 60177278738 Phase IV
3 601374244 Phase III
4 60142444 Phase II
5 60166621344 Phase V
6 6066923847874 Phase I
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.