Registration is open for Inspire 2024! For today only receive up to 20% off. This promotion is discounted off the Early Bird price and includes 20% off for conference-only passes and 10% off training passes. Register here!
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.
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.
Hello all, I have a duplicated macro inserted after each duplicated multiple filter but i created dynamic file path to separate and save the records as you all suggested but now how do I incorporate the batch macro insertion after it?