How to create dynamic filter using data in my column

Question

Hi Community,

I have a data and I want to filter column A (Province) and set individual output files per province, without using multiple filter tools. Is there a way to put this into a macro function?

ProvinceProd CodeQtyAlbertaAA100AlbertaAB200AlbertaAC300AlbertaAA400AlbertaAD500AlbertaAA600AlbertaAA700British ColumbiaAA100British ColumbiaEG200British ColumbiaIA300British ColumbiaBP400British ColumbiaBP500British ColumbiaBP600SaskatchewanWD100SaskatchewanWD200SaskatchewanWD300SaskatchewanWD400OntarioBA100OntarioBA200OntarioBA300OntarioBA400OntarioBA500OntarioBA600

Sample File for Filter.xlsx

JoshuaGostick · Accepted Answer

Hi @Edgar_Ryan_C,

You can create multiple out files based on the value under Province using a single Output tool. If you select Take File/Table Name From Field as shown below, you will be able to create a unique Output for each unique value for Province. Each output will be filtered to that specific Province.

Let me know if you have any questions or issues with this.

Thanks,

Josh

CharlieS · Accepted Answer

Hi @Edgar_Ryan_C

To write an output for each Province value, a macro is not necessary, nor is a tool for each unique value. What I recommend is using a Formula tool to write the various output file names as a new field and have a single Output tool write all those files. The Output tool configuration gives you the option to "Take File/Table Name from Field" which can be set to a field with multiple values.

Check out the attached workflow that writes a uniquely named .yxdb file for each value in the [Province] field and let me know if you have any questions.

KP_DML · Accepted Answer

As @JoshuaGostick  said, you can have the Output Tool do the work for you. Workflow attached.