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.
Solved! Go to Solution.
Have you tried using a text input?
thanks for your reply, Joseph. Yes, I have but if the SQL code that I'm pasting has more than 1 line, it only pastes the first line...
Hi @janez_007
If you have the focus on a cell in the Input tool and paste the SQL, the entire string will get copied into the field. You just won't be able to see the entire thing in the Input tool because of the embedded new line characters. If you look at the results window and double click on the field so that it shows up in the cell viewer, you see that the entire string is there.
Dan
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
this works, thank you!