Resolve CSV
This component can be used to take a csv file and issue a resolve and create a new version with a suffix of .resolved.csv and functions enclosed in {} will also be resolved.
The VIP Test Data stack contains very powerful data functionality.

Example data generation functions.
These can be explored using Excel and typing =datagen or =VIP. The Resolve CSV function allows you to store these functions inside a csv file and then resolve the values to static values for use by other components, for example create messages etc.
If you wished to have a random number between 1 and a 100 you could include
=DataGen.Random.RandomInt(1,100)
inside a cell.
To store the value you can enclose the value inside {} or prefix the equal sign with a quote
{=DataGen.Random.RandomInt(1,100)} '=DataGen.Random.RandomInt(1,100)
You can also perform Test Data Catalogue find or makes as part of the resolve

Example Test Criteria (lookup) in a Test Data Catalogue – The criteria is 183 (look in the URL)
To incorporate a look-up use the following format:
{parTestID=195,parBarcodeType=634STPremium,parStartString=0039328350024500224}
parTestID Get this from the url
Other parameters are from the Input section of criteria definition
Flow Location
C:\VIPTDM\MasterFileController\ResolveCSV.vip
Submit through Executor Form
Yes
Use as part of models and TDA
Yes
Used in Solutions
Operation
The input file is converted to an output file in the same folder with a suffix .resolved.csv
Parameters
Parameter | Description | Internal |
parUseControlFile | True or FalseUse ResolveTheseFiles.txt – which is created by generatecsvThis contains a list of files to be resolved | N |
parCSVFilePath | The folder containing the CSVs | N |
parAPIURL | Modeller URL | Y |
parAPIKey | Modeller API key | Y |
Output Data
A list of files to be resolved.
How to use the component
Invoke the component as part of a direct submission form, or more likely as part of a generalized workflow of components.
TEST MODELLER SOLUTIONS AND COMPONENTS COMPONENTS