Append Existing errors

Question

Hello Experts,

I am writing a row to a database with the designer. I am using the "append existing" with the odbc database connection. Workflow works fine when there is atleast a row of data to write to the database, however when there are 0 rows to write I get an error.

Append field map does not match number of insert columns for table:<table name>

The table in the database has a primary key and when there is no data to write it still tries to write something and fails. I added a filter to check in the workflow  on the pk column being not empty before writing, however even if the pk column is empty that branch that is writing to database is being triggered.

Is there a tile that will help prevent this?

TIA

RolandSchubert · Answer

Did you connect the input data (i.e. Select tool) with the "D" anchor of the macro and a Count tool with the Question anchor?  Maybe it would be helpful if you provide some screenshots.

Yuri24 · Answer

My input to the macro is coming from a select tool after performing multiple joins between multiple tables and some spreadsheets. The macro however doesnt seem to accept the input throwing "The control parameter "name" must be mapped to a field" upon connecting the output of select tool to the macro input.

In the yxmc file I have already edited the connection to the database from Test.yxdb

Am i doing something wrong?

DawnDuong · Answer

@RolandSchubert  this is a neat trick the i never knew before!