command line capabilities alteryx

Hi Friends,

i have developed an application where i use greenplum as back end, excel as my front end and alteryx to load the data to greenplum. i want to invoke the alteryx file from my excel UI screen but not sure how to do it. I request your help to solve this issue.

Workflow

Settings

Tips and Tricks

Common Use Cases

Best Practices

Accepted answers

NicoleJohnson

You should be able to create a macro in Excel with the following VBA code that will open up your Alteryx app (or any other Excel or non-Excel file):

ActiveWorkbook.FollowHyperlink Address:="(Location of Alteryx File)", NewWindow:=True

... Though sounds like @patrick_digan probably knows more about what he's talking about. But in the most basic scenarios, the above VBA should work.

All comments

patrick_digan

@aysha6029 Do you have a private Alteryx server setup? If you have a private server setup, I'd be glad to share the vba we have in place. We're doing exactly what you're describing where excel is the front end and Alteryx is the engine. It has massive potential at our organization.

NicoleJohnson

You should be able to create a macro in Excel with the following VBA code that will open up your Alteryx app (or any other Excel or non-Excel file):

ActiveWorkbook.FollowHyperlink Address:="(Location of Alteryx File)", NewWindow:=True

... Though sounds like @patrick_digan probably knows more about what he's talking about. But in the most basic scenarios, the above VBA should work.

@patrick_digan if @aysha6029 didn't have an Alteryx Server, do you think your solution would work where you only have Designer and buy that "Desktop Automation Add on", too? I've never tried it, but it the absence of a Server it might super cost effective.

aysha6029

@patrick_digan our project do have seperate server environment. and i do have alteryx desktop and server setup in my personal computer

aysha6029

@NicoleJohnsonWow! that works. thank you..

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703