Posted: 21 Nov 2019 10:25 EST Last activity: 26 Nov 2019 4:44 EST
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***
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?