Thanks Heloisa, I have gone through those docs while searching steps / procedure for sub-process.
One of my friend helped me in providing the steps. I will explain it here too for good understanding.
Step 1 : Create a Output Log Message utility step and read the data from excel sheet.
Step 2 : Never provide it as "Local / Random". As, we are going to Assert the rowCount. If rowCount matches with main step and subprocess step then comparison will start.
2 Excel sheet have following headers "Desc", "Product_ID"
Step 3 : Create a TestCase under Subprocess Section. Create 2 Output Log Message utility step. 1 for Read Data from 2 excel (Keep it as local), and other for Comparison using "Ensure properties are equal" Assertion
Step 4 : Mark the checkbox as enable "Thisis a subprocess". You can able to see two paramters (Subprocess Input and Subprocess Output).
Step 5 : Enter the Excel Sheet headers in "Subprocess Input parameters" as mentioned below You can add / modify / delete . "Prospective Input Parameters" will get autopopulate. U cannot add / modify /delete. "Subprocess Output properties" will get autopopulate from the main step "properties", which we are enabling
Step 6 : Navigate to "main TestCase" and click on "Subprocess Step". Right side, you will identify the "Result properties". Enable the properties Desc, Product_ID. This will get displayed in "Subprocess Output Properties" of "Subprocess TestCase".
Step 7 : Create Filters for storing the property from 2 Excel sheet. (Store property from one key to another)
For Sheet 1 : Desc_1, Product_ID_1;
For Sheet 2 : Desc_2, Product_ID_2;
Create a "Ensure properties are equal "Assertion in Subprocess TestCase for validiting the "RowCount" in "OutputLogMessage" Step.
Create 2 more assertions to validate Desc_1, Desc_2 are equal and Product_ID_1, Product_ID_2 are equal.
Step 8 : Now, Execute the "main TestCase". For the first iteration, it will take the first excel sheet and read 1st row and navigate to subprocess step, it will pickup the second excel sheet and read 1st row.
a) It will validate "rowCount" are equal. If yes
b) It will validate the property for the first row (Desc_1, Desc_2 and product_ID_1, product_ID_2)
If no, it will fail and end the test.
For the second iteration, it will take the first excel sheet and read 2nd row and navigate to subprocess step, it will pickup the second excel sheet and read 2nd row.
a) It will validate "rowCount" are equal. If yes
b) It will validate the property for the second row (Desc_1, Desc_2 and product_ID_1, product_ID_2)
If no, it will fail and end the test.
goes on till end.