Hyperlink a column in render excel output file to another sheet in same output file

Question

Hello experts...

need some guidance on if this can be achieved

i have a render tool that outputs into an Excel in 2 tabs : TAB: Summary and Detail.

What i am looking for is a Column in Summary to have a Link , when clicked to go to Detail tab. (same output excel sheet).

Would be amazing to have..if when i click on the link , it filters the data in detail data by the ID from summary tab.

Summary Tab

IDNameCountryActiveDetails123abcxyzYCLICK HERE345jajalllYCLICK HERE

Detail Tab

IDDescription1231.abc1232.location needs to be changed345transfer of duties345location change not allowed

so basically, click on the link in summary tab for ID 123, it should go to detail tab and only show data for ID 123.

Let me know if this can be done as this is something on the output file from render tool.

Thanks

DanielG · Answer

@SR  the blob tools will create the 400 Excel files from the 1 template in a second then you can batch the data by the same grouping and pump data to the corresponding Excel that was just created.  I don't really ever use the Render Tool for Excel as I prefer the VBA to handle the formatting anyways since Alteryx cant even slap on AutoFilters or anything like that.  😁

Here is a simple example I built for someone a few months ago that might help illustrate the point better.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Create-Update-multiple-template-files/td-p/1115754

SR · Answer

thank you. i looked through the blog but dont think it might work as a solution for me because my output through render tools creates 400 files based on Group Name but will keep exploring.

DanielG · Answer

@SR -- you will need to build a template spreadsheet that you can then push the data down to with the required Excel formatting/functionality already built out.  You can't build Excel functionality like that in Alteryx.

I have done this numerous times with XLSM files that handles alot of formatting/functionality for the End Users.

Read @NicoleJ 's Blob Tool Blog from last year

https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/970280