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

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?

Input

Error Message

AMP Engine

AMP-Engine

Accepted answers

nagakavyasri

@cpet13 : check if this helps

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/A-field-was-missing-a-closing-quote-in-record-xxx-Tab-Delimited/td-p/334911

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

All comments

nagakavyasri

@cpet13 : check if this helps

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/A-field-was-missing-a-closing-quote-in-record-xxx-Tab-Delimited/td-p/334911

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703