Hi ,
I am trying to read multiple sheets in a single excel workbook and insert into DB but i am not able to read it. Its currently reading same sheet for multiple times (which is same as number of sheets i have ) so same row is coming
Thanks you yes, Now i am able to write into Excel writer but i want to write all these sheets into DB, how to do that. because DB INSERT is giving SChem_name.Table_Name_ITERATION error. saying below:-
Execute failed: [Teradata Database] [TeraJDBC 16.20.00.13] [Error 3810] [SQLState 42S22] Column/Parameter ‘schema_name_tablename.Iteration’ does not exist.
The Loop End node optionally creates a new variable called Iteration. Sounds like your database isn’t set up for that. You can either change the table schema to include an Iteration column, or uncheck the “Add iteration column” box in the Loop End node to turn that off.