odbc

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

sheridany
Posts: 39
Joined: Thu Nov 15, 2007 4:20 am

odbc

Postby sheridany » Fri Mar 26, 2010 1:51 am

i need to find rows of data from a very large teradata table and am wondering if I can use text pipe to find those rows as it brings the data in. I have a list of company names that will be contained in one of the fields but they will not match perfectly as some company names are abbreviated etc. To do it in the database, I would have to write a case statement and a when clause for 82 different companys in a table that has 70 million rows. I would rather add the company list and restrict the lines so it only keeps the lines with the companies from the list. Is this possible?

User avatar
DataMystic Support
Site Admin
Posts: 2164
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: odbc

Postby DataMystic Support » Fri Mar 26, 2010 7:57 am

Hi Sheridan,

Yes - you could certainly use a 'Filters\Remove\Remove lines\Remove non-matching lines' filter, with company search text of

Code: Select all

^(aaa|bbbb|cccc)


for the initial part of each company name.

Doing it in TeraData is likely to be quicker, especially if you're pulling the data via ODBC.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 8 guests