Hello,
We have a use case that would benefit from being able to insert into an AFTable from an analysis. This would work in the same way that event frames do, where a trigger condition is meet that causes the row to be inserted. The variables from the analysis could be mapped to columns in the table in the same way that they are mapped to attributes in an event frame.
Having this ability would enable customers to then query information from the AFTable in their AF database via the existing Table Lookup data reference. This would allow for a full closed loop method to calculate and store data that is not sutable for storage as time series data in PIPoints, and then use the data in their AF model.
Some limitations may need to be applied in order to implement this, such as the AFTable must not be linked in order to use it in the insert analysis.
Currently we generate event frames and use a custom data reference to extract data from the event frames into the AF model. This is a workaround that often is difficult to maintain, but is currently the only viable method of storing non-time series data that will be used by elements in the AF database.