AnsweredAssumed Answered

handle macros in excel dataset/Ways (other than macros) to form jdbc insert statement in an excel dataset by concatenating values

Question asked by Rahul_THD on Mar 29, 2016
Latest reply on May 3, 2016 by Rahul_THD

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!

Outcomes