Update Value Node Not Working

lnforman

Hello,

I have a file directory hooked up to a macro that begins with a Control Parameter, Update Value and Input Data node. However, when I run the workflow it will run as many lines as I have files in my folder but it continuously runs the macro over the first file instead of moving on to the next file in the folder.

Control parameter = file path

Update Value - I have tried many different configurations here but not exactly sure how this works. 

Input Data - which file path should this be set to?

Thanks!

BenMoss

Hi @lnforman 

It's quite hard to support your post without an image, on the face of it it sounds like your doing all the right things, however, I've provided an image of what I believe your configuration should look like.

The path for the input file within the batch macro should not matter, it is essentially acting as a placeholder. It should however be a file similar in type to those you are expecting to read in through your process.

By that I mean, if you are looking to read in xlsx files, set your input file within the macro to be an xlsx.

Within the update value you will then set your action to overwrite the entire filepath string.

For each record that goes into your control parameter, the action will then overwrite the path given in the input data tool and as a result input each file.

I hope this helps, but please feel free to ask further questions, especially as I may have completely missunderstood what you are looking to achieve.

Ben