Hi All,
I have the same problem as in this question:
https://community.alteryx.com/t5/Alteryx-Connect-Gallery/Split-a-stream-into-multiple-streams-based-on-values-in-a/m-p/35094#M1166
Basically need to split data into multiple streams based on the values in a column. Question: Is there a way to do this without dumping the data into an intermediate set of files?
Thanks
Hi @dmitry_berman
I believe you are looking for the Filter Tool. Would there be any dynamic reasons where a filter would not work?
Thx,
Hi TonyM,
The column I'm splitting on can have many different values which are not always present and I'm not 100% positive of the "universe" of values that may appear. A "filter chain" in this case would be very cumbersome to set up and error prone.
Thnx
Hi @dmitry_berman,
You can do some configuration in the output tool as given below, It will create files by grouping your desired column values. You will get as many files as distinct values exists in that field.
Depending on how many values you expect, this is simpler than a batch macro. I had a similar issue and just summarized by the values in the field in question, assigned a record ID to them, and then did filters by the record ID. If you had a relatively small amount of values per run, even if the values differed day to day, you could capture them all this way.
