Display Large Data In PivotTable Dynamically with column and row names

posted on July 30th, 2022

Answered

santhosh krishna asked on July 30, 2022

We have large Files(Gb) CSV or JSON and the column names is nonstatic we want to load data and display it as a pivot table Can you Help with this

Public

Nadia Khodakivska ⋅ Flexmonster ⋅ August 1, 2022

Hello,

Thank you for contacting us.

Flexmonster provides two options for handling and analyzing the big data sets:

Flexmonster Data Server:
Flexmonster Data Server is responsible for fetching data from a data source, processing, and aggregating it. Then the data is passed to Flexmonster Pivot in a ready-to-show format. The Data Server significantly reduces data loading time and enables analyzing large datasets.
For Flexmonster Data Server, it is possible to set a data refresh time interval via the DataRefreshTime option. This way, Flexmonster Data Server will refresh the data with the specified rate. For example, you could configure it to refresh the data every several minutes. Please see our configuration guide for more details.
Custom Data Source API:
Another option is to implement the custom data source API, a protocol developed by our team that the Flexmonster Data Server is built on.
The custom data source API protocol provides a single set of requests and responses for connecting Flexmonster to any data source. This provides full control over how the data is processed, and you could create any desired data processing layer and manage how the data is refreshed.

Please let us know if it works for you. Feel free to contact us if other questions arise.

Kind regards,
Nadia