I need to execute dynamically some sql's. So the flow should be like:
tTeradataInput - tmap - tFileOutputExcel - tTeradataInput2 Basically, tTeradataInput is generating the sql based on some parameters, afterwards with tTeradataInput2 I need to execute the sql generated with tTeradataInput.
Do you have any ideas how I can do it? Right now I have problems in converting data obtained in tFileOutputExcel (csv) to convert it into a txt file, so afterwards to read it with a tJavaRow and execute the last tTeradataInput2.
Maybe you have a simple solution. Can you please help me with an idea?
not sure I understand You correctly, but:
You can use tFlowToIterate for store any flow data into variables, than You can use this variables value on feature steps in SQL, like:
"SELECT col1, col2, col3 FROM "+((String)globalMap.get("v_TableName")(+" WHERE "+((string)globalMap.get(v_ParamOne))+ ... etc
