CLS Conversion

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
mdemerick@dow.com
Participant
Posts: 16
Joined: Thu Apr 03, 2008 9:45 am

CLS Conversion

Post by mdemerick@dow.com »

I created a rule set for standardizing weights into the ISO standard. However, my output shows that it sometimes doesn't convert it.

An entry in my CLS files is as follows:

IN INH T

The way I understand it, if it sees IN, it converts it to INH and gives it type T, which can be referred to in the PAT file. It is also my understanding that the CLS file is automatically run before entering the PAT file.

I also have a conversion table that is similar to the CLS table. The entries are similar to that above, but without the type, since that is entered in the PAT file when using CONVERT_R.

Is my understanding correct? Am I making some elementary mistake?
jhmckeever
Premium Member
Premium Member
Posts: 301
Joined: Thu Jul 14, 2005 10:27 am
Location: Melbourne, Australia
Contact:

Post by jhmckeever »

However, my output shows that it sometimes doesn't convert it.
Is there any pattern to the 'sometimes' when the conversion doesn't happen?

What have you determined from trying example data through your rules using the Rules Analyzer?

Do you have any other entries in your CLS file involving the classification of the token 'IN'?

J.
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
mdemerick@dow.com
Participant
Posts: 16
Joined: Thu Apr 03, 2008 9:45 am

Post by mdemerick@dow.com »

I fixed the problem by running an explicit conversion every time. If I didn't, then the CLS file aparently didn't do anything.
vairus
Participant
Posts: 52
Joined: Thu Feb 07, 2008 8:02 am
Location: Johannesburg

Post by vairus »

could you send me the data which doesnot get converted or its general pattern.

send me the output field name in dictionary too
vairamuthu
Post Reply