[Help] Filter Data in Alteryx based on the inputs in EXCEL

Hi Folks,

I want to filter the records which is an output in Alteryx flow. The filtration of records should be done based on the selection in Microsoft Excel.

Example:

In the Excel sheet, I will have a drop-down list (1,2,3,4,5).

In Alteryx, I have a table with the following records:

ID	Name	Age
1	John	25
2	Peter	35
3	Amy	45
4	Parker	12
5	Sun	22

So, If I select '1' in Excel, the selection should be fed into Alteryx and the records for ID = 1 should be fetched.

How do I work on it?

Thanks in advance.

Workflow

Expression

Events

Accepted answers

saveeshkumar

Hi @Arcane ,

In Excel on button click event call the below code.

create bat file with
"C:\Alteryx\bin\AlteryxEngineCmd.exe" "C:\Community\Task.yxmd"

Thanks

All comments

atcodedog05

Hi @Arcane

Here is how you can do it.

Workflow:

Hope this helps : )

select ID.yxmd

Arcane

That was a lightning-fast reply. But, can we have something like a macro or on-click event, where if I click SUBMIT button on Excel, the Alteryx flow starts and it gives the output?

atcodedog05

Hi @Arcane

Sadly excel cant trigger Alteryx workflow.

saveeshkumar

Hi @Arcane ,

In Excel on button click event call the below code.

create bat file with
"C:\Alteryx\bin\AlteryxEngineCmd.exe" "C:\Community\Task.yxmd"

Thanks

atcodedog05

Hi @saveeshkumar

That's nice. Would this work on gallery too?

saveeshkumar

Hi @atcodedog05 ,

Need to check :-)

Thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703