Alteryx Report Passing Report Column as a Parm in URL

[CharliePII]

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 solution]

Assuming your input data looks like this:

Column A

NJ

PA

AZ

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

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

2. 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.

3. 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              URL

NJ                         https://www.myurl.com?State=NJ

PA                         https://www.myurl.com?State=PA  

AZ                         https://www.myurl.com?State=AZ

[CharliePII]

Thank you seeing the syntax you used and overall approach helped me , and I was able to get it working now.  :)