Dataframe in ObjectScript manipulation

[eduard93]

After retrieval of Dataframe (as json) how can user manipulate it?

• Expose as temporary table
• Expose as ResultSet

Ideas?

[eduard93]

https://community.intersystems.com/post/use-table-object-part-sql-query

[eduard93]

df
id prediction accuracy

table
id col1 ... colN prediction accuracy

UPDATE table (prediction, accuracy) VALUES (df.prediction, df.accuracy) WHERE df.id = id

[eduard93]

34ee19a

[eduard93]

Test code: https://gist.githubusercontent.com/eduard93/32d6525cc2ff4ea3ad9ab4a1d052fd85/raw/a03a64c5c826fdf18d6108514f7ff0bf5e77d41b/test.xml