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

[sethuram85]

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?

[binu_acs]

@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]

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.