in a transformation i am reading a table with table input. For each row of this table, which is a list of table names, an "select count(*)...." is executed.

Now my problem. The source table, where i read the tablenames from, contains a column, which should be updated with the result of this select.

What is the best way to achive this. I tried everything that comes into my mind with the update step. Nothing works. Even the docs don't bring me any further. I am still a newbie to this and definitly missing something.

So, can anybody help me out with a short desciption how to handle this?