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
Solved! Go to Solution.
Hi @subin1234,
Here's how you can come to the output you desire.
The summize and append tool allows us to create an 'all possible scenarios' between order numbers and test cases. We can then use a join tool against our 2nd dataset to identify aspects from our all scenarios table that are missing, these are those that have been rejected.
Example workflow attached.
Ben
Can u send the screenshot of the configuration of the tool used in the workflow. I am getting error message while trying to open the workflow. Thanking in advance.
I am using 11.05.
Thanks for the sample. Its working fine. But Error is throwing on appends of more than 16 Records: Is there any way to get rid of this error as I will be dealing with a lot of records.
Yes, in the append fields tool, check the option at the bottom 'allow all appends'
Ben
thank you very much. Its working fine