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

[Midhuna]

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 

http://example.com/updates/20200816

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 ?

[randreag]

Hi @Midhuna 

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

[Midhuna]

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

[randreag · Accepted solution]

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

[ImadZidan]

Hello @Midhuna ,

here is an example. two input text used as two connections.

It will give you an idea.

I hope it helps.