Copying results of a function derived dynamic data table over to a new table

[Richard Lake 4]

I have table that results from outputs of a DCA function and since the output table gets replaced after every new run, I need a way to store that data in a table and also gets appended after each new run with new data.  Seeing if anyone had a dxp that shows this in action so I can incorporate.  Thanks!

[David Boot-Olazabal]

Hi Richard,

What do you want to accomplish?
Do you want to overwrite the new data table after each run? If that is the case, you can try to use this iron python code, that copies an existing data table to a new one (or if it exists, replace it):

You can trigger the code via a change in a document property (triggered by a data function).

In case you need a 'one-time' copy and only want to append rows to that data table, you may want to use this iron python code to append rows:

I don't have a dashboard ready with any of the scripts applied, but you can give it a go.

Kind regards,

David

[Richard Lake 4]

Thanks so much, it's the latter scenario. I'll give this a whirl, thanks! @David Boot-Olazabal

Edited April 11 by Richard Lake 4