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
Hi TMC,
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