Get Free Trial

Display Large Data In PivotTable Dynamically with column and row names

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

1 answer

Public
Nadia Khodakivska 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

Please login or Register to Submit Answer