Downloading large data table

Question

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.
------------------------------

markshnier__you · Answer

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 · Answer

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 · Answer

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.
------------------------------

markshnier__you · Answer

That field may be labelled as a date but it does not appear to be an actual date field it probably has the text of a date in it.&nbsp; Do you have the ability to customize the report? Even viewers often have the ability to create personal reports. If you have that ability you will be able to use the menu at the top right corner which looks a little bit like an abacus to customize the report. Then you will be able to make your own filters based on say date created or something like that------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

evanmartinez · Answer

Hi Bob,Another option if you aren't able to create a personal report to filter the data is to touch base with the admin for the app your using and see if you can get the permissions you need to make that kind of report. It is possible they made the role without the permissions but would be happy to help you get access to the data you need for the work you are doing if they get that feedback.------------------------------Evan Martinez------------------------------

Forum Discussion

Downloading large data table

7 Replies

Related Content

insert newline into API downloaded text

Filter records based on table connection

Do unused tables related to currently used tables cause functionality problems?

Download Dashboard Report after filter?

Summary Table

Recent Discussions

View query record if single record otherwise view query list

How do I unhide an app that I have no idea what it is named?

Gnatt plugin

Justifications for Table Report Columns

Quickbase JMP connection