Working with JavaScript Tables

You can use JavaScript Tables to collect the data from network resources and process it in the form of relational tables.

For example, you need to collect the stock exchange information from a financial portal for a certain period of time and save this information so that you can use it in QMF as a typical relational table.

For this, you create a JavaScript Table, specify its structure, and save it to a JavaScript data source or a virtual data source. In the JavaScript Table editor, you write a script that populates the table with the required data retrieved over HTTP or HTTPS. When you run a query based on the created JavaScript Table, the script retrieves the data and saves it in a table that is used by the query.

If it is necessary, you can use external functions and objects from different modules that are either saved in a repository or located on a web server.

You can run queries based on a JavaScript Table and use them to create quick reports, forecasts, or add them to visual dashboards.