CSV (or TSV) file is a simplest data source in SeekTable: it is enough to click on Upload Data, choose a local file, and wait until file is uploaded. That's all: now you can create summary report (pivot table, chart) or view/filter/sort CSV data rows with usual 'flat' table.
All parameters are detemined automatically:
CSV file may be compressed with zip or gzip, and this is only option if you want to upload large CSV file that is greater than upload limit (50Mb). Uncompressed CSV size might be up to 500Mb; SeekTable works fine with files of this size and pivot table generation should not take more than 5-10 seconds.
It is possible to define special expressions for custom handling of CSV values (parse timespans, apply replace rules etc).
In some cases you might need to refresh saved pivot table reports by uploading newer version of the dataset. This is possible in one of the following ways:
https://www.seektable.com/cube/feb3828c57474791a5ee92b83d4195e0In this case cube ID is
feb3828c57474791a5ee92b83d4195e0.zip(if CSV file is zipped)
Note: data refresh is possible only if new CSV file has all columns present in the old version of CSV file (with the same names); new columns are OK.
It is possible to define expression-based (calculated) dimensions that are evaluated before aggregation step (on row-level). For example, if you have date column (say, "Some Date") it is possible to calculate quarter or day-of-week in the following way:
Date.Quarter(Column["Some Date"])(for quarter)
Date.DayOfWeek(Column["Some Date"])(for day-of-week)
Date.Week(Column["Some Date"])(for week number)
Column is a special variable that provides access to the context CSV row values; you can use column name directly
if it doesn't contain spaces or special symbols - for example,
SomeDate. More details about expression syntax you can found
In case if you want to create a pivot table by CSV file that exceeds upload limit (even zipped) you still can do that in one of the following ways: