Forum Discussion

kroman's avatar
kroman
Icon for Helper II rankHelper II
3 years ago
Solved

Getting sorted data in bunches

Hi All We have a dataset with 100K rows in the following format: And we have a flow that is getting data from this dataset Due to the fact that flow cannot get all 100k rows in one go we are...
Flow
Large Datasets
  • johnt75's avatar
    johnt75
    3 years ago

    You could use the WINDOW function, that allows you to order by whichever column you want and you can provide the offsets you need.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You could use the WINDOW function, that allows you to order by whichever column you want and you can provide the offsets you need.

kroman's avatar
kroman
Icon for Helper II rankHelper II
3 years ago

Finaly works with 

WINDOW(0, REL, 10 , ABS