Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Write To In-DB require a WHERE clause

kosie-snyman
7 - Meteor

Using version 20221.xxx of Designer. I use a Batch Macro to Update a table in a database, but I get the following error:

Error: Write Data In-DB (82): Fields must be mapped for conditional statement.

 

Below screenshot of my workflow:

kosiesnyman_0-1664923639742.png

Scrrenshot of Write Data in-db setup

kosiesnyman_1-1664923752133.png

 

How do I map the fields? 

 

2 REPLIES 2
Alayna
8 - Asteroid

 

Do you use a macro input for your batch macro? I ran into a similar issue and the solution by CharlieS below helped me out - checking the show field map option in the macro input tool: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-All-fields-must-be-mapped-for-th...

kosie-snyman
7 - Meteor

I use a Control Parameter for my Input since I am working through a list of files in a directory and not able to find where I can implement the solution proposed by CharlieS. Below screen shot of start of Macro

kosiesnyman_0-1664999137218.png

Also screenshot of where I use the Macro

kosiesnyman_1-1664999252126.png

 

Labels