Can Data Driven .xlsx file values be used without a field value to match on?

Document ID : KB000074916
Last Modified Date : 19/07/2018
Show Technical Document Details
Introduction:
How the Data-driven matching will happen when Excel or CSV file has more columns than what the request data has in a transaction.
Question:
Can Data Driven .xlsx file values be used in VSI response without a field value to match on in the request?
Environment:
DevTest 10.x versions
Answer:
Yes. For example, you have 4 Request data arguments and you have 6 columns in Excel file. The request matching is going to happen on all the Request data arguments and the corresponding 2 columns which were not mapped with Request data but these can be used in your VSI response. 

Note:
Excel file can have as many columns as it can but all the Request Data Arguments in a transaction need to be mapped to the Excel data. For example, if a transaction has 5 Request Data Arguments then all the arguments need to be mapped to the Excel Data. Mapping 1/2/3/4 will return No Match.
Additional Information:
. https://docops.ca.com/devtest-solutions/10-1/en/using/using-ca-service-virtualization/using-devtest-portal-with-ca-service-virtualization/create-data-driven-virtual-services#CreateData-DrivenVirtualServices-MapResponsetoDataSetColumns.
. https://docops.ca.com/devtest-solutions/10-1/en/reference/data-set-descriptions/read-rows-from-a-delimited-data-file-data-set 
. https://docops.ca.com/devtest-solutions/10-1/en/reference/data-set-descriptions/read-rows-from-excel-file-data-set. 
. https://docops.ca.com/devtest-solutions/10-1/en/reference/data-set-descriptions/create-your-own-set-of-large-data-data-set.