This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi- I just spoke with Alteryx support about this and they suggested I add this to the Community page. Basically, for an incoming data stream, I'd like to be able to "split" the file into unique files based on the value of a particular column. I've attached a file for reference- in this file, it would be great to be able to have the incoming data split according to the Brand or Vehicle Type fields, with each stream available for further manipulation after the split.
While this can be accomplished one at a time with the Filter tool, for large files with 50+ "split-by" values, it would be great to accomplish this in one step.
Without knowing the actual business process you need, you should be able accomplish the "splitting" by creating your process in a batch macro and then running process through the list of the values one at a time.
Thanks for your prompt response. I work in healthcare and have sets of diagnosis and procedure codes that are used to categorize patients. For patients falling into different categories, there are a number of data operations that we undertake that are unique to the patients in that category-
I like your idea about writing the data out and reading the files back in- may give that a shot-
I came across your reply in researching a similar issue. Basically, I have a file with transactional information and I want to split out and analyze transactions based on the bank of origin. I created the Temp Output, pointed the Directory input toward the temp file, but am having trouble configuring the dynamic input tool to split out the transactional data on the way back in. Do you have any additional guidance on this tool?