StepType_Data

Data

Calling Data in a Step Sequence allows you to create parameters from a row of data in a datasheet

How each column is used:

Column Name	Value
iID	The ID used to uniquely identify the current Step Sequence
iSeq	Optional/Purely cosmetic, only used to help you structure you step sequences
cStepType	Data
cField	The ID used to uniquely identify the row of data in the datasheet
cValue	The name of the data sheet containing the data to save as parameters
cTiming	The path to the folder containing the data sheet that contains the data
cExpect	Not Used
cOnError	Not Used

Example usage:

In this example Business Process 13 is adding a person in the application, this could be adding a student in a School Database or a new customer in a retail sales system.

Given the following datasheet that is stored at \TestingServer\TestingShare\DataSheets\BP13Data.tsv

iID	GivenName	Surname	DateOfBirth
BP13Case001	Tom	Jackson	2010-08-08
BP13Case002	Megawatikesuma		2001-06-18
BP13Case003		Franklin
BP13Case004	震嶽	張	1969-03-29
BP13Case005	Афанасий	Аминев	1945-10-01

iID	iSeq	cStepType	cField	cValue	cTiming	cExpect	cOnError
Seq001	1	Data	BP13Case001	BP13Data	\TestingServer\TestingShare\DataSheets

When the data step is called in this example 4 parameters are created as follows:

Parameter Name	Value
iID	BP13Case001
GivenName	Tom
Surname	Jackson
DateOfBirth	2010-08-08

These Parameters can then be used in future steps by placing {} around the parameter name e.g {GivenName}. For more details see the section on [Parameterisation]