Dynamic Input Tool - A field was missing a closing quote in record

[cpet13]

Hello,

I have a folder that has files placed into it frequently. My workflow is using the Dynamic Input Tool in order to retrieve the most current file. But I just started getting an error message saying, "A field was missing a closing quote in record XXX." When investigating this, I found some solutions suggesting it had something to do with the AMP engine; however, they are all just in regards to the input tool and the solution doesn't seem to be applicable for the input dynamic tool. Is there a solution for this error in the Dynamic Input Tool?

[nagakavyasri · Accepted solution]

@cpet13 : check if this helps

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/A-field-was-missing-a-closing-...

If the above doesn't help, check the Input template path and SQL query of the Dynamic Input tool.

[cpet13]

Thank you for the response! The option, AMP Only: Allow Newlines in Quoted Fields, was in the Input Data Source Template section and was the fix. Thank you again for the quick response!

[Raj]

is this solved?

[cpet13]

Yes, the comment above solved it for me. Thank you!