Batch macro to update fields

Question

Hi I have a batch macro to run is there a way to update various fields while the batch macro is executed.  I should be able to get only one row but the row should be updated as the batch runs. Please find attached a example. Let me know if you require any details

Batch macro.PNG

rzdodson · Answer

@lumjingbki will echo above what @caltang said with regards to providing more details around what you are attempting to do.

I suspect that you are updating a WHERE clause in your SQL code to filter incoming data based on a list of values you are passing through your batch macro. If that is the case, then the answer is "Yes, you can absolutely do that". It'll require that the list of values in your Where clause are passed into the ? anchor of your batch macro, then updating your Control Parameter to update the portion of your SQL syntax that needs to be updated. Once this is set up, your values will pass in one at a time, grab the relevant data pertaining to the specific syntax of the updated query, and return the expected singular row of data. Once all batches pass through, every batch record is unioned together to create a data set that can be used for further analysis.

caltang · Answer

What is the input and what is the output supposed to be? Your batch macro is hooked to a text input tool, not sure if that's by design or...? Because you won't be able to connect it with your data in that case.

Please provide relevant data to this use case, and kindly provide your criteria in as much detail as possible. If you have a workflow built halfway, kindly export that over as well.

To export a workflow go to: Options > Export Workflow. Kindly do NOT send a "Save As" copy.