input tool for a long string (SQL query)

janez_007

hi all,

I am searching for an input tool (or any other workaround) which would enable me to manually paste a long string (SQL query) to a field value and use it later in the workflow (as an input to update another SQL query in the Dynamic Input Tool).

Edit: the SQL code that I would like to paste has several rows (line breaks)

Any suggestions?

Thank you.

danilang

hi @janez_007 

Sorry about that.  

Try this.  Put your cursor in the first cell and click the paste button(in green below) 

this will paste the query into multiple lines.  follow up with a summarize tool using a \n as the delimiter to get 

Dan