Conversion Table Problem

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
U
Participant
Posts: 230
Joined: Tue Apr 17, 2007 8:23 pm
Location: Singapore

Conversion Table Problem

Post by U »

We are getting the following error message.
QualityStage Test wrote:Standardization process failed. Table contains an invalid entry.
The above error occurred in the following line of file
C:/IBM/InformationServer/Clients/Classic/TempRules/IDD7DIGIT.TBL
\FORMAT\ SORT
We have created the TBL file in the Quality directory as follows:

Code: Select all

;; QualityStage v8.0
\FORMAT\ SORT=Y
2125288 "Western Sahara"
2125289 "Western Sahara"
3906698 "Vatican City"
6189162 "Cocos Islands"
6189164 "Christmas Island"
The file put into the TempRules directory when we use the Test facility includes the complete first two lines (that is, the "=Y" is present), but none of the data.

Provisioning the rule set (for international telephone numbers) made no difference - this error keeps appearing.

Can anyone suggest what the problem might be?

(This is our first experience using the CONVERT action. We're pretty confident that the PAL is correct syntactically.)

Thank you for your time.
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

Hi,

From your description, it sounds like you are trying to everything from the command line. If true, you should use the GUI instead. You can create the table in the GUI. If you do not, then it will never know about the table, and you will not be able to use the rules tester.

Having said that, the problem may be that you need to make sure the table is UTF-8. The GUI does that for you :)
Regards,
Robert
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

To continue Robert's theme, the thing you're looking for in the New menu is Lookup Table (TBL), which you will find under Data Quality.

Once the new table has been created, you double click to open it in your selected editor (default Notepad).
Last edited by ray.wurlod on Mon Jun 02, 2014 7:36 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
U
Participant
Posts: 230
Joined: Tue Apr 17, 2007 8:23 pm
Location: Singapore

Post by U »

Yes, it seems that NotePad was the culprit. Using TextPad allowed accented characters to be included.

Unfortunately the QualityStage Test utility can't display them, but they standardise correctly.

Thank you very much for your time.
Post Reply