Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How do we apply filter node/ option on the header row in the excel output file

sethuram85
6 - Meteoroid

Is there anyway we can apply filter option on the header row within the Alterxy workflow, there is a solved solution that is insisting user to manually open the output excel file and apply filter. Can someone help?

2 REPLIES 2
binu_acs
21 - Polaris

@sethuram85 I dont think you can apply filter option in the excel worksheet using alteryx, may be you can call a vb macro through the command tool in Alteryx to apply filter in the worksheet

danbostrom
8 - Asteroid

If I'm understanding your question correctly, the Dynamic Select tool might be useful for you. You can choose whether to include or exclude fields based on the name of the field. When you open the Configuration window of the tool, you can click "Select via a formula" at the top. Then you'll be able to write a formula in the expression editor below and you can use the [Name] field to refer to the name of the field that you want to keep or omit based on a particular condition. For example: Contains([Name], 'time') will select all the fields that contain the word time and all other fields will be dropped.

Labels
Top Solution Authors