Alteryx Designer Desktop Discussions

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

Alteryx Report Passing Report Column as a Parm in URL

CharliePII
5 - Atom

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

2 REPLIES 2
Hammad_Rashid
11 - Bolide
 
 
 

 

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:

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

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

Labels