Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
RÉSOLU

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

Arcane
Météore

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:

 

IDNameAge
1John25
2Peter35
3Amy45
4Parker

12

5Sun22

 

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.

7 RÉPONSES 7
atcodedog05
22 - Nova
22 - Nova

Hi @Arcane 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1645183634237.png

 

Hope this helps : )

 

Arcane
Météore

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
22 - Nova
22 - Nova

Hi @Arcane 

 

Sadly excel cant trigger Alteryx workflow.

atcodedog05
22 - Nova
22 - Nova

Hi @Arcane 

 

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

 

atcodedog05_0-1645184794843.png

 

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

 

Hope this helps : )

 

saveeshkumar
Comète

Hi @Arcane ,

 

In Excel on button click event call the below code.

 

 

saveeshkumar_0-1645185134635.png

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

 

Thanks

atcodedog05
22 - Nova
22 - Nova

Hi @saveeshkumar 

 

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

saveeshkumar
Comète

Hi @atcodedog05 ,

 

Need to check :-)

 

Thanks

Étiquettes
Auteurs des meilleures solutions