Question
virtusa
IN
Last activity: 23 Jan 2017 8:53 EST
Question related to working with data tables
i have values to be stored in data tables but where 1 value will have 10 values like
1 prasanth
1 praveen
1 raj
1 rajamf
1 vdsd
1 sdvds
1 vsd
1 svs
1 vsd
1 sdvv
1 sdv
2 rajaq
2 nvs
2 jnlk
3 bskvj
3 nds
3 fvf
like this i have redudency in data so is there any proceess to eliminate this redudency like normilization in sql
can any solve this?
***Moderator Edit: Vidyaranjan | Updated Categories & Title***
Pegasystems Inc.
US
I am not sure I understand why you want here. But FYI, data tables have been replaced by local storage since 7.1.7. You may want to take a look at that option:
local data storage
Local data storage is a feature that lets you store data records for a data type without having to manually create or maintain database tables.
In the Data Designer, you can access local data storage on the Sources tab for the data type. Use the Local Data Storage wizard to create a local data source.
Pegasystems Inc.
IN
Hi Prashanth,
I am not sure if you need to check the redundancy while entering or you already have the Data stored in Db and you wanted to check the dependency.
If you already have the data stored, When retrieving data from the DB, you can use Report Definition and you can check the option for 'Remove-duplicate rows' option.
If you want to check the redundancy while inserting the content, there are several ways you can acheive the requirement. One such is writing an activity which can do obj-browse and check if it is a duplicate. If no, you can commit into that data class.
Regards,
Venkatesh.K