Textual ETL Practice
Textual ETL is the process of reading text and producing a relational data base suitable for analytical processing. The text can come from any electronic source and the results can go into any relational data base. In addition to this we use Excel consolidation software where an organization can read and consolidate their many spreadsheets as well as Email consolidation where email can be read and filtered before going into Textual ETL. Email typically contains spam and personal email which does not belong in a corporate data base. We remove the unwanted email before processing.