This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!
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:
Scrrenshot of Write Data in-db setup
How do I map the fields?
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...
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
Also screenshot of where I use the Macro