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***


Keep up to date on this post and subscribe to comments

November 21, 2019 - 10:30am


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">

November 22, 2019 - 1:01pm

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?


November 22, 2019 - 1:18pm

November 23, 2019 - 8:37am

November 26, 2019 - 4:44am


I'm not able to reproduce this in 7.3.1

could you please provide some screenshots for clear understanding.