We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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