Batch Macro field not found (coming from input file name as field)

Hi, I have created a batch macro to combine data from different Excel sheets.
I checked 'output file name as field' in the template input since I needed the full path for the sake of data categorisation and transformation within the workflow.

Assuming I have re-named the file path as 'Full Path' within the workflow, I run into an error "The field 'Full Path' is not contained in the record" (for each worksheet) when I try to run the batch macro to update data from the different Excel source worksheets.

I think this is as a result of the renamed path having a different string/ worksheet name from the update parameter string.

Does anyone know how I can make the batch macro work and have the path updated for each worksheet?

Thanks.

Workflow

Parse

Batch Macro

Preparation

Interface Tools

Accepted answers

Qiu

@MRoyW

Try to check the Questions Tab in the Macro Configuration Window.

I think you need to re-map the field since you changed the filed name.

All comments

mbarone

Do you have a screen shot of your configuration of the tools before the macro, and the config of the macro itself?

MRoyW

configured to update worksheet identifier part of stringmacro outputError for full path not found - MAYBE due to renaming of field which includes string to be updatedparsing of full file path to get categorisation data - This field is renamed as 'Full Path'

Hope this helps

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703