Add new records as per the fixed limit

[sn2200]

i have dataset with record fluctuating record count but will be always less than the limit of 1000. How can i find and add additional records in the same data for eg if the record count is 950 then i want to generate the remaining 50 records in the same data. The existing data has Record ID field. 

[Pilsner]

Hello @sn2200 

I have tried to replicate and attempted to solve your challenge (I have taken a max row count of 10). The workflow is attached below.

There are two inputs, one for your data and one for the maximum row count. This limit can be changed by simply overwriting the max value, in the text input.

Next, the number of records already in the data is counted (in my example there are 8 records already).

Using the generate rows too, I have generated 2 more rows to reach the required maximum of 10. This is dynamic as the generate rows tool is set to start counting from the value of the current row count (8) and stop counting when it reaches the maximum (10).

Next, you need to impute the dummy data values, for these new rows. I have just set the value equal to "X" but if you have some other logic to use here instead, I would be happy to help. 

Finally, I unioned the original data to the new imputed data, and sorted by Record ID.

I hope this helps, please let me know how you get on. 

Regards - Pilsner

[binuacs · Accepted solution]

@sn2200 one way of doing this

[sn2200]

Thank you Pilsner & Binuacs!