...
In a database, create a table. Now have PhixFlow read data from that table, modify it and write it back to that table.
Solution:
- Create A a datasouce to your DBdatabase.
- Create a DB Collector database collector to take data from your datasource (via a SQL query) into a stream.
- Update the stream to modify one of the attributes of the data (for example, by multiplying it by 2)
- Create a DB Exporter database exporter to write the update back to the same DB database table.