Forum Discussion

BobThomas1's avatar
BobThomas1
Qrew Cadet
3 years ago

Downloading large data table

I tried to download a large table over 600,000 records into a CSV file, but it exceeds the limits. 

I read some old posts that say to divide it into chunks. I would like to do that. As a viewer of the file I am unable to do anything but download the file. I could get by with just a subset of the data to use in some new reports. 

I'm not sure how to do this?

------------------------------
Bob T.
------------------------------
  • As long as you have the ability to make a report, you should be able to make a filter.  You might try to see what range the Record ID#s are in and make some report which filters on blocks of Record IDs.  Or we can help you with a report formula to filter on an <ask the user> based on day # of the week, like 0 through 6 and run 7 reports.​

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • BobThomas1's avatar
      BobThomas1
      Qrew Cadet
      Hi Mark,

      The problem is I am just a viewer of the app. So I don't have access to
      the filters or to field settings.

      • BobThomas1's avatar
        BobThomas1
        Qrew Cadet
        This might work. I see the columns have filters. This one is an encounter date, so it covers four years. Say I want just the data from the last quarter Oct-Dec 2021, how would I enter the date range here?



        ------------------------------
        Bob T.
        ------------------------------