Create Excel hyperlink formula in Alteryx

[PrMc]

I would like to include the Excel hyperlink formula e.g. "=(https://www.google.com/maps/@53.453595,-2.7804529,16.75z,"store)" in to Alteryx so when the output is pasted within Excel. the formula with the hyperlink is already created.

The Lat and Longs will be changing depending on the record.

when I have tried this it does not work.

"=" && "HYPERLINK" &&"("&&"https://www.google.com/maps/@"+[Latitude]&&","&&[Longitude]+"z"&&","+"Store"+")"

[atcodedog05]

Hi @PrMc 

Here is how you can do it. You need reporting tools for this.

Workflow:

1. Using formula tool to create the hyperlink.

2. Using report text tool to link the formula.

Hope this helps : )