Need help to fix the Error

[raunakrenge]

Hi All, 

I have directory and it has 3 files as of now (all files has same structure just new records gets added every month), it gets updated every month so there will be new file every month. I am getting error as mentioned below - 

Error: Directory_Input K (3): Record #3: Tool #5: The field schema for the output "Output5" changed between iterations.

Could you please help me with this. I have attached input files, test workflow and macro for this.

Thanks in advance, 

Raunak

[LordNeilLord · Accepted solution]

Hey @raunakrenge 

You need to change the output mode of your macro to Auto Configure by Name in the interface designer properties

[danilang · Accepted solution]

Hi @raunakrenge 

It works properly when I try it with your 3 files.  Check the output of your Directory tool to ensure that you've only got 3 records and that they're the correct ones.  If not try, changing the File specification in your directory tool from "*.*" to something like "InterBusiness_Time_YTD_Detail*.xlsx"

Dan

[raunakrenge · Accepted solution]

Thanks for your response but I am not able to edit the properties, its disabled for me, could you please suggest what might be the reason for this? Attached screenshot.

Thanks,

Raunak

[danilang · Accepted solution]

hi @raunakrenge 

You need to edit the properties from inside the macro, not from the main workflow

Dan  

[BenjaminBreton]

Thank you! This is what solved my issue 😉