Hi Guys,
I have two files as below
| testcasename |
| FV_001 |
| FV_002 |
| FV_003 |
| FV_004 |
| FV_005 |
FV_006 |
2nd file
| OrderNumber | TestCaseName | Status |
| 111 | FV_001 | Pass |
| 111 | FV_002 | Pass |
| 111 | FV_003 | Pass |
| 111 | FV_004 | Pass |
| 111 | FV_005 | Pass |
| 222 | FV_001 | Pass |
| 222 | FV_002 | Pass |
| 222 | FV_003 | Pass |
| 222 | FV_004 | Pass |
| 222 | FV_005 | Pass |
| 333 | FV_001 | Pass |
| 333 | FV_002 | Pass |
| 333 | FV_003 | Fail |
| 333 | FV_004 | Pass |
I need to each testcase in file1 to go through each ordernumber and testcase in file 2 and give me an output as below.
| OrderNumber | TestCaseName | Status |
| 111 | FV_001 | Pass |
| 111 | FV_002 | Pass |
| 111 | FV_003 | Pass |
| 111 | FV_004 | Pass |
| 111 | FV_005 | Pass |
| 111 | FV_006 | Rejected |
| 222 | FV_001 | Pass |
| 222 | FV_002 | Pass |
| 222 | FV_003 | Pass |
| 222 | FV_004 | Pass |
| 222 | FV_005 | Pass |
| 222 | FV_006 | Rejected |
| 333 | FV_001 | Pass |
| 333 | FV_002 | Pass |
| 333 | FV_003 | Fail |
| 333 | FV_004 | Pass |
| 333 | FV_005 | Rejected |
| 333 | FV_006 | Rejected |
If the testcase is not present in file 2 for a particular order number then the output should have the status as rejected for that ordernumber and testcase.
Is there any way this can be done
