Split table into several tables based on condition

Question

Hello, I want to split the following table:

TypeDataA

123456A4535435A343242B988798797B87876B713123C23424C32432

Into the following 3 tables:

A

123456A4535435A343242

B988798797B87876B713123

C23424C32432

However, I could have more than 3 types. I want this to be dynamic/automatized for the number of types that I have.

I want to output to tables "in memory" that I can then use in other tools, and not to files.

How could I do it? Thank you!

gabrielvilella · Answer

I'm assuming that you have a specific rule that you need to apply depending on the type. You need to create all the possible rules, separating the data using filters as @Qiu mentioned. If there is no data for a certain type, nothing will happen. If in the end you combine all them into a single table, you can have all those rules and filters within a macro so your workflow will look cleaner.

Qiu · Answer

@cutehappybear 
We can use the filter tool to split the data stream but it will not be dynamic as you said.

Would loev to see if there is apppoach can do it.

It can be easy to write file though.