Dynamic Filter

[Padashwi]

Hi All, I'm looking for a solution where i can perform dynamic filter.

Case : I have list of codes , based on the codes the data should be filtered dynamically, also the data should be divided into different sheets based on the filtered code. These codes may change in future , hence looking for dynamic filter. Please suggest

[IraWatt]

Hey @Padashwi,

I've attached an example macro which achieves this:

Any questions or issues please ask :)
HTH!
Ira

[Padashwi]

@IraWattplease provide me the yxmd format workflow.

[IraWatt]

You will need to correct the file locations in the yxmd and yxmc files, I've attached them

[Padashwi]

@IraWatti'm facing an error , attached the error page for your reference. Please suggest

[IraWatt]

@Padashwi This error is due to this:

you need to pass the codes to the macro

[Padashwi]

@IraWattThis is working Perfectly ! But, we need the output in different tabs of a single file , instead of different sheets. i have attached the sample output for your reference.

[IraWatt]

@Padashwi The output on my PC is identical to your desired file. This may be because you need to click this action tool and only update the sheet part of the address like in the screenshot below

[Padashwi]

Hi , As instructed below, i find it is helpful. I'm getting appropriate results. But i'm unable to save the workflow in the Alteryx server and i'm unable to get the output as there are no output anchors. I'm sharing the snip of the workflow. Please advise.

[IraWatt]

Hey @Padashwi, to add an output anchor just use the macro output tool:

What issue are you encountering on the server?