I have the following problem in Devtest. I have a JDBC step which reads the SQL statement from an excel dataset. But the column in excel that has the SQL statements is calculated with the help of a macro and the step is unable to read that from the dataset. Any suggestions on handling this?
Actually, I am trying to form an insert statement in a column by concatenating values in other columns and have written a macro for that function. So, if you can suggest any other way to form the insert statement, that would be of great help too!
Thanks very much!