Question
Infosys Ltd
IN
Last activity: 7 Oct 2024 6:19 EDT
How to retrieve only certain records from Database table using dataset rule?
We have a database table named 'claims' we want to copy resolved records from this table to another new table 'ClaimsRecord'. We are planning to achieve this using a dataflow rule.
We thought of retrieving records from database table using a dataset rule, but we have no idea about pulling only resolved records from it. Can anyone have ideas and solutions for this?
Accepted Solution
Updated: 3 Oct 2024 12:10 EDT
Maantic Inc
IN
I don't think that's possible. Instead you can refer the data set in a data flow and add a filter shape after it to take on Resolved cases, and then post on the new table.
Updated: 7 Oct 2024 4:56 EDT
Infosys Ltd
IN
@SohamM95Can I limit the number of records pulled by a dataset? for example if I have 19 Million records in the db, can I pull only 1 million by using a dataset atleast?
Maantic Inc
IN
Directly from a dataset you can't. Instead you can retrieve whole dataset and filter certain records to a temporary dataset, from there you can again extract the whole thing whereas this time its only filtered records that'll be extracted from the new set.