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

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.