Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Post Reply
Posts: 36
Joined: Thu Nov 15, 2007 4:20 am


Post by 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: 2222
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Re: odbc

Post by 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

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.

Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads

Post Reply