cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Gopi
Level 8

Clear Collect Excel data

How can I clear collect data on more than 500 rows which is there in excel?

 

Data looks like the attached image

 

My function: ClearCollect(Data,Filter(Table1, ID <=500));Collect(Data,Filter(Table1, ID > 500 && ID <=1000));Collect(Data,Filter(Table1, ID > 1000 && ID <=1500));Collect(Data,Filter(Table1, ID > 1500 && ID <=2000));Collect(Data,Filter(Table1, ID > 2000 && ID <=2500));Collect(Data,Filter(Table1, ID > 2500 && ID <=3000))

 

which collects only 500.

 


Accepted Solutions
Anonymous
Not applicable

Re: Clear Collect Excel data

You can increase this limit to 2000. However if you have more than 2,000 you won't be able to use Excel. Consider switching to Azure SQL Server which can have unlimited number of records with use of delegation.

 

To increase the limit to 2000 go to File -> App settings -> Experimental Features -> Data row limit for non-delegatable queries


All Replies
Anonymous
Not applicable

Re: Clear Collect Excel data

You can increase this limit to 2000. However if you have more than 2,000 you won't be able to use Excel. Consider switching to Azure SQL Server which can have unlimited number of records with use of delegation.

 

To increase the limit to 2000 go to File -> App settings -> Experimental Features -> Data row limit for non-delegatable queries