Question

3
Replies
1358
Views
JeffGo Member since 2017 14 posts
Appriss, Inc
Posted: 2 years ago
Last activity: 2 years 6 months ago
Closed

How to create test data to insert into a database (how to create a page row)

I have a test case for which I want to create some test data. I want this test data to be available no matter which environment I am in (Dev, QA, etc). So to do this I want to add 3 to 4 rows of data to the database that the Data Page will be referencing.

Ex. Suppose I have an database table (which is replacated by the class) Names, which have fields, "ID", "First", "Last"
I want to add the following data:
1, "Frank", "Franklin"
2, "George", "Gershwin"
3, "Harry", "Henderson"

To do this, I started to create a Data Transform. In the Pages & Classes, I've added:

Rows | Code-Pega-List
Rows.Row | Names

What do I do on the Definitions tab? I've tried to do an Update Page or Append and Map to, but I don't seem to be doing something correctly.

RowActionTargetRelationSource
1Update PageRows
1.1SetID3838
1.2SetFirst"Frank"
1.3SetLast"Franklin"
2Update PageRows
2.1SetID3839
2.2SetFirst"George"
2.3SetLast"Gershwin"
Data Integration
Moderation Team has archived post
Share this page LinkedIn