Split tables according to a field value

TMC

Forums

Hi all :)
I have a table "TableOne" that contains n fields. In field "Fieldn" there are codes like C1, C2, C3 etc.
I would like to be able to split tables: TableOne_C1, TableOne_C2, and so on.
Basically like: on every change in the column X create an extract with the new value as table-suffix.
Any suggestions?
regards from Berlin

Brian Element Wed, 10/26/2016 - 08:49

Hi TMC,

Have you checked out the Key Value Extraction?  It shounds what you are looking for.  It allows you to create a new file based on a key, in this case your Fieldn.  Also it uses the key as part of the name of the new file.

Check it out and let me know if that is what you are looking for.

Brian

TMC Wed, 10/26/2016 - 08:52

Hi Brian!
of course, I have thpught about the extraction ^^ but how can I loop through the values to find only the destinct values which should be used for the key value extraction? :)
Hope that makes sense,
 
regards

Brian Element Wed, 10/26/2016 - 09:12

Hi TMC,

Is that what you are thinking about?  I am don't understand what you need differently from what the key value extraction can give you.  In the key value extraction you select a key that will list the distinct values that you can then select from.

TMC Wed, 10/26/2016 - 10:01

sry for that. I use IDEA in ENglish and thought you would mean an extraction that contains only records with a specific key. I will have to find out how the key value extraction function is called in my GUI^^TY!
btw: using IDEA 8

TMC Wed, 10/26/2016 - 10:40

Ah, I see "Extraktion nach Schlüsselfeld" :D I was expecting it to be unter the "Analysis" Ribbon
 
Thanks a ton, I will check it out tomorrow,
regards