Alteryx Report Passing Report Column as a Parm in URL

Question

Greetings!

I am trying to pass the value of one of my report columns into a URL that I am using as a Another Column on the report but it is not working .

When I reference the column in the URL it thinks the field is a URL link and puts a http in front of it , thinking that may have to do with the Hyperlink Option the Report Text has.

Example

Column A      Column B

NJ                 https//www,myurl.com?State=[ColumnA]

PA

AZ

Not sure if this is possible in Alteryx or not , thinking it should be ?  Just need help with the Syntax required to do it .

Thanks

C

Hammad_Rashid · Accepted Answer

Assuming your input data looks like this:

Column ANJPAAZYou want to create a new column, Column B, with URLs based on the values in Column A.

* Add a Formula Tool: Drag a Formula tool onto your canvas in Alteryx.

* Create a New Field: In the Formula tool, create a new field (let's call it "URL") by using the following expression:

'https://www.myurl.com?State=' + [Column A]This expression concatenates the constant part of the URL with the values from Column A.

Make sure to replace [Column A] with the actual name of your Column A field.

* Output the Result: Connect the Formula tool to your output tool (e.g., Select tool or Output Data tool) to see the results.

Now, your output will have two columns:

Column A              URLNJ                         https://www.myurl.com?State=NJPA                         https://www.myurl.com?State=PA  AZ                         https://www.myurl.com?State=AZ