Question
CIGNA Health Solutions India
IN
Last activity: 21 Jun 2021 10:35 EDT
Copy Data Table rows and add few more rows with changes to same Data Table
HI All,
I have a Data Table as Output ready from LookUpTable, i want to do follwoing things with this DataTable
- Out_ Dt (dataTable ) has 4 rows as a output from Lookup Table
- I want to keep those 4 rows as it is and add
- 4 more rows to same table with few changes in Column
- so it will total 8 rows along with Primary 4 rows
Attached file will give clear picture on Requirement, please help in doing this with Components.
Pegasystems Inc.
US
@praneetv9588 The lookup table has a method called Add which is what you'd use to add these additional rows. You need a field in the lookup table that would have a unique value. Based on your screenshot, none of the columns you have defined are unique. You can create your own key field by concatenating the data on each row into one unique string if you wanted to ensure you could not add any duplicates, or you can create a field in the lookup table and set AutoIncrement to True. When you add a row with this field added to the the table, you won't need to provide it a value (if you set it to AutoIncrement) and it will instead just add a new row with that value being an integer one greater than the prior row.