Reply
Highlighted
Level: Powered On
Posts: 100
Registered: ‎11-17-2016
Accepted Solution

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
Super User
Posts: 491
Registered: ‎04-27-2017

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

-------------------------------------------------------------
Consider up voting the idea to make SQL Connector Secure

View solution in original post


All Replies
Super User
Posts: 491
Registered: ‎04-27-2017

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

-------------------------------------------------------------
Consider up voting the idea to make SQL Connector Secure