Concatenate a string with Part from Input Text Data and part from a Query output

Hi ,

I need to generate a URL string by part of value derived by running a SQL Query

I have Text Input with Column URL as "http://example.com/updates/"

and Then I need to run a sql query to get a timestamp and use that timestamp to make the final URL update as

when I used the "Input Data" I don't see a place to send this output to , I was planning to use Formula to join these 2 values together

any help please ?

Preparation

Accepted answers

Ah ok, you need to use an append fields connected to the two inputs so the data is in the same record

If I understood your question , yes you need to concatenate using a formula tool the field url with the result of the sql query

Cheers

Yes, but the formula tool accepts only one connection , so I set the connection from Input Data , It's unable to read the Field from Input Text field