I am having difficultly with an iterative macro.
Only the first entry passes through the macro. The second record fails and generates the following error message.
Error: The field “URL” is missing. Compare the tool configuration with the input stream
The screenshot of the macro below includes the configuration of the macro in Interface Designer as well as the output of the Iterative Output, that clearly shows the inclusion of the URL field. The Sample tool that precedes it is set to Skip 1st N rows with N=1.
Solved! Go to Solution.
hey @hellyars
Are you able to attach a workflow with this problem extracted? I have my suspicions but its not an easy one to replicate without the data/workflow.
Cheers,
TheOC
Do you have a filter tool to test if your condition is met - or are you just running a set number of iterations.
The fields (names/types) have to be the same between iterations so you need to make sure your select tool is sending the same field names/types in the same order the loop.
@TheOCand @apathetichell Iterative macro attached. I included a text input tool with 10 records that can be used to jump start a workflow. Its the same table used in the macro input. Thanks.
Try this - reset the field name in a select tool right before the loop.
Also made small changes to interface designer - no longer goes for 1000 loops (but you can adjust) and doesn't give an error if it has union different fields.
And obviously make sure your browse - workflow continues from the F anchor...
@apathetichell LOL!!! I needed to rename URL to "ToDetails" so that it can be renamed URL.
@hellyarsOn the good news
1) your macro works
2) you did a great job on it
3) you won't do that again...
so win/win/win?
Hi @hellyars
Probably the simplest way to fix this is to branch directly from the Macro Input as opposed to branching after the Select
No extra tools required.
Dan
@danilangEven funnier. Thanks.