I've seen several request for this, but you guys seem resistent. We need a companent to execute some generic sql (more than one statement) after moving and massaging data. It does not need to be with each row and has nothing to do with the dataflow. Its just SQL that need to run at that time in the flow. I con't use tMysqlRow because there is no row. After this is executed I need to perform other actions. can you guys just give us a generic sql execute function. Virtually all etl tools have these and I've used them all.
In particular, I'm confused on how each line of the file (in the tFileInputRegex) is passed to the tMySqlRow. Is it an iteration?
Yes, you can use a tFlowToIterate component, eg:
tFileInputRegex --row1---tFlowToIterate--iterate--> tMySqlRow
on tMysqlRow, you could get value of each column of tFileInputRegex like this: (String)globalMap.get("row1.columnName")
Best regards
Hi together, This should be working too without the tFlowToIterate. But you must change the code to get the data. I think it is something like: row1.myColumnWithSql Bye Volker
