deleting rows in decision table add empty rows at the bottom
We are using Pega 7.3.
We have a very simple decision table with one input column and one output column.
We noticed that we have values that were repeated in the input column and we wanted to have each value of the input column only once. So, we exported the table, removed the rows in Excel, saved the file and imported the table back in Pega.
The result is a table with a series of empty lines at the bottom of the table before the last "otherwise" line.
How can we clean up this table without having all those empty lines at the bottom ?
Using the Pega UI will take us hours since we can remove only one line at a time and we have about 100 of them to remove.
***Edited by Moderator: Lochan to update platform capability tags***
Intact Financial Corporation
CA
Hi,
I just noticed that the xml shows too many lines under :
<pyResults REPEATINGTYPE="PropertyList">
we have 803 entries under that and only 740 under
<pyPropertyValues REPEATINGTYPE="PropertyList">
Pegasystems Inc.
US
Based on your writeup, my initial thought was that this sounds like a genuine bug during import but I'm unable to reproduce this in a 7.3 system to confirm this. Attached a sample DT I played with.
If you can provide your Excel that has the duplicate values, I could attempt to import that into a DT here locally and see if your problem is reproducible. Also, have you looked deeper into Tracer data when you select the updated excel file and click Import?
Thanks.
Pegasystems Inc.
US
Do you see a difference if 'Allowed to return values' is checked?
https://community.pega.com/support/support-articles/blank-rows-display-decision-table-exporting-it-excel
Maantic Inc
IN
@CarissaW_GCS This works nice
Pegasystems Inc.
IN
HI,
Please refer the below link.
https://community.pega.com/support/support-articles/unable-delete-empty-rows-decision-table
Thanks