Add row to table when row in DAT merge changes

Beginners
1

Hi,
I have DAT merge with 1 row and 3 columns, this changes periodically (only ever 1 row) and when it does I want to add the row to a Table DAT but I am struggling.
I have tried using the DAT Execute onTableChange and onRowChange with various things like appendRow or specifying the exact row but am not having any luck.

The target table has the same number of columns as the merge DAT I am using as source.

Can anyoe help?
Thanks

2

Can you post a file with what you have so we can see why it is not working? Since appendRow should do what you want.

3

I have tried to simplify it by just trying to append cell 0, 0 from a table dat named select_last_image when it updates into another table called table1 using appendRow as follows, but instead of adding the data from the specified cell to the target table1 it is adding the text ‘select_last_image’

def onTableChange(dat):
op(‘table1’).appendRow(‘select_last_image’)[0, 0]
return

4

You are adding the string ‘select_last_image’ in your example. That syntax should actually give you an error with [0,0] since appendRow returns an int.

This will grab row 0 from the operator select_last_image

op('table1').appendRow( op('select_last_image').row(0) )

This will grab cell 0,0 from the operator select_last_image

op('table1').appendRow( op('select_last_image')[0,0]) )

More info here: DAT Class - Derivative

Hope this helps

5

Thanks so much for the swift reply!
I am getting an error using
op(‘table1’).appendRow( op(‘select_last_image’)[0,0]) )
about an unmatched )
I tried removing the last ) but get a TypeError: NoneType object is not subscriptable

6

Removing the last ) is the correct syntax. NoneType object is not subscriptable would mean there op(‘select_last_image’) is returning None, i.e. there’s no op with that name in the network of your script.