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

[Arcane]

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.

[atcodedog05]

Hi @Arcane 

Here is how you can do it.

Workflow:

Hope this helps : )

[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.

[atcodedog05]

Hi @Arcane 

You can build an app where you can enter the ID and it shows you the output like below.

Learning path on analytics app: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Creating%2... 

Hope this helps : )

[saveeshkumar · Accepted solution]

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