Arcadia Enterprise enables you to save tabular data as its own table, and writes it back to the database. It also enables you to produce a dataset based on data exposed in a visual, which may be used for self-referenced application stacking. Note that
To follow these steps, you may choose to prepare by importing data from datafile SnP500.csv, and creating a dataset from it. We named our dataset S&P 500 Historical Data.
For a Table visual: In the visual edit view, select the necessary fields from the Fields menu on the left, and place them onto the Dimensions, Measures, and Filter shelves.
For a Query visual: make the necessary edits in the SQL statement at the top of the visual.
Make all necessary changes to the shelves, such as filtering, ordering, calculation, and so on, so they can be saved in the new table.
On the top right menu, click (ellipsis) icon, and then select Save Table from the menu.
In the Create a materialized table or logical view modal window, chose one of the following options: