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 ?
Solved! Go to Solution.
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
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
Ah ok, you need to use an append fields connected to the two inputs so the data is in the same record
Hello @Midhuna ,
here is an example. two input text used as two connections.
It will give you an idea.
I hope it helps.