Iterative Macro: Second Iteration Fails w/ Missing Field Error Message

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 &ldquo;URL&rdquo; 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.

Macros

Help

Accepted answers

apathetichell

@hellyars

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.

2021-05-13 (1).png

And obviously make sure your browse - workflow continues from the F anchor...

2021-05-13 (2).png

i2i_nvr_parse_html.yxmc

danilang

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

All comments

TheOC

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

apathetichell

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.

hellyars

@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.

i2i_nvr_parse_html.yxmc

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703