Question

3
Replies
1466
Views
Close popover
Jeff Gosnell (JeffGo)
Appriss, Inc

Appriss, Inc
US
JeffGo Member since 2017 14 posts
Appriss, Inc
Posted: April 11, 2018
Last activity: April 20, 2018
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.

Row Action Target Relation Source
1 Update Page Rows
1.1 Set ID 3838
1.2 Set First "Frank"
1.3 Set Last "Franklin"
2 Update Page Rows
2.1 Set ID 3839
2.2 Set First "George"
2.3 Set Last "Gershwin"
Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.