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?
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.
@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?
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.