You’re offline. This is a read only version of the page.
372
Hello, everyone!
I used this formula to grab my excel data, my excel has 10000 rows.
ClearCollect(DataProdOrder, Filter(Perform, Value(No)<=2000), Filter(Perform, Value(No)> 2000 && Value(No)<=4000), Filter(Perform, Value(No)> 4000 && Value(No)<=6000), Filter(Perform, Value(No)> 6000 && Value(No)<=7000))
But, the data are shown just 2000 data, how to fix it?
Thank you in advance.
@firda59 Does your Excel file Contains any column like Id on that basis we can fetch the records ,
If you have column like Id or any other column on the basis of column we can fetch the records
Ex.
ClearCollect(colExcelData ,Filter(‘Name of Table’,ID<=2000),
Filter(‘Employee’, ID<=4000 And ID>=2001),Filter(‘Employee’, ID<=6000 And ID>=4001 ),Filter(‘Employee’,ID<=8000 And ID>=6001 ),Filter(‘Employee’,ID<=10000 And ID>=8001 ))
hello @satishdongare
still cant work, the list just shown 2000 rows
2000 is the maximum and Excel does not support any delegable functions. There are workarounds to get up to 4000 rows however:
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
Hi @firda59
There is limitations to fetch the records from the excel or any database , at a time you can only fetch 2000 records.
so you can try this one
Collect(ds1,datasource); //Collects the first 2000 items
Collect(ds2,FirstN(Sort(datasource,Descending),100)); //Collects the rest of the items
Collect(dsfinal,ds1,ds2) //Combines the two datasources
Hope it will helps you
Thanks !
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
Share
Report
All responses (
Answers (
