Batch Macro still not working

[Deba93]

I have created a batch macro to extract all the files from a particular folder. Two of the files are not being extracted due to difference in data type for a particular column. I have attached the macro. Anyway we can do this.

Looking forward to an interesting answer. I have already checked the Interface Designer. It is selected to "Auto Configure by Name(Wait Until All Iterations are Run)".

[Deba93]

@Qiu it worked, thanks a lot for being so patient with such a trifling issue. However, what I was doing wrong was checking the box replace string in update value tool inside the batch macro. removing that sorted out the problem. 🙂

[Qiu]

@Deba93 
Happy it finally got sorted out.😁

I think it again then realize the issue may not be the check box.

Its the way you are using macro.

You made a macro, but you are still reading the data all in once, so the schema issue arises when input tool reads all the data, and the Select Tool would not be workding since the error occurs before it.

So to conclude, use macro inside a workflow, not along.

[Deba93]

@Qiu yes that was the main reason to be precise 😀

However, have another question regarding this, how to check exactly whether my macro is actually processing all the files from the folder. Or is it actually dropping them