The scenario was need to add Excel sheet in the Resources and arrange data in to the Reactive Grid.And filter the Duplicate Records from that Grid.and Download the filtered Records into Excel as Duplicate Records.How to acheive this please provide me an OML.
Hi @Vidudhala Guruvamsi
This use case is not something Data Grid supports and is a use case that would make more sense to be treated on your server action before populating the Data Grid with the spreadsheet data.You can use the system action ListDistinct to remove the duplicates and only after that use the ArrangeData to populate the Grid.
Cheers,GM
Actually thing was I want to filter Duplicate Records in the datagrid using button Action Logic After rendering all the data from excel which is added in the resources into the datagrid." instead of filtering from Excel I want to filter inthe dataGrid".When user is clicking on " GetDuplicates " button the Datagrid Should want to update with Duplicates which is there in excelsheet.And when user is clicking on "Download Duplicates into excel" button the Duplicate Records want to export into a another Excel.
"The Oml was Attached here please update here if Any solution that you guys have"
Hi @Vidudhala Guruvamsi,
Add Logic to get dupicate values from list
Hi @Jothikarthika - EONE i have analyzed code in the Oml which is given.And I have Question in that.What is if I have a Lakhs of Records in Excel(for example I have around 6 lakhs Student Records in Excel in the Resources) will this logic work fine?
yes, working fine Lot of record in excel sheet,but I think it may take some time
Hey! Actually I have added a Excel sheet which is Having Around 5lakh Records.the logic is Not working as Expected.Is there Any other way to acheive this functionality.
Remove duplicate values by using inbuild list distinct function.
Below attached oml to get remove all duplicate values from list.
No it is not Working.List Distinct is not ready take 6 laks Records it is Strucking overthere i have waited for morethan 10min but it is not at all working.please let me know is there any other way to acheive it. @Jothikarthika - EONE
can you try this logic in process.because process run on background so you got some better performance
Hi,
You need to use Timer to process the large data in the background. DataGrid will create problem if you try to load more than 10k records.
One more thing , while processing the lacs of records keep in mind Server CPU and Memory usage as well, it may slowdown you application.
Thanks
Hi Vidudhala Guruvamsi ,
Try This :https://gokulprasanth-m.outsystemscloud.com/Datagrid_poc/Home
Thanks,
Gokulprasanth M