Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Midhuna
5 - Atom

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 ?

4 REPLIES 4
randreag
11 - Bolide

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
5 - Atom

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
11 - Bolide

 

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

ImadZidan
12 - Quasar

Hello @Midhuna ,

 

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

 

It will give you an idea.

 

I hope it helps.

Labels