Description of format results from Column Analysis

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
dquan97
Participant
Posts: 13
Joined: Tue Oct 20, 2015 9:04 am

Description of format results from Column Analysis

Post by dquan97 »

After running a column analysis and clicking View Details for a business name field, I went to the Format tab to see the formats identified. I saw only a single entry: "NA." I've seen this before when the values were blank, but viewing the Distinct Values panel on "NA" showed full business names like McDonalds Corp or Joe's Pool Bar. I'm wondering why IA is showing "NA" as a format for these values. :shock:

EDIT:
Data Class: Text
Properties: String
Format > General Format: NA
Last edited by dquan97 on Fri Oct 23, 2015 10:49 am, edited 2 times in total.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Just a guess here but perhaps... "North America".
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Format of NA usually means NULL. It may also mean, rarely, that the data value is not appropriate for the defined data type.

Check that you drilled down on the correct format.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

... or that. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

What Ray said..

To add a bit more color commentary, in this context, 'NA' means 'Not Available'.
Regards,
Robert
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

For the record, my guess was predicated on the OP being shocked at the value and thus assuming that it couldn't possibly mean "Not Applicable" which is of course the first assumption. Silly me. :P
-craig

"You can never have too many knives" -- Logan Nine Fingers
dquan97
Participant
Posts: 13
Joined: Tue Oct 20, 2015 9:04 am

Post by dquan97 »

ray.wurlod wrote:Check that you drilled down on the correct format. ...
I clicked on "NA" and in the Distinct Values panel, I saw the name values mentioned in OP. The Drill Down button does not lead to anywhere.
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

Copying the response I provided on developerWorks:

Have you run column analysis more than once? Did you 'update existing tables' when running the column analysis the second time? If you did, then the second run will 'update' the results of the first.
Otherwise, you should probably open a PMR because I would not expect those distinct values to show under that format.
Regards,
Robert
dquan97
Participant
Posts: 13
Joined: Tue Oct 20, 2015 9:04 am

Post by dquan97 »

I have run the column analysis probably twice and clicked Rebuild Inferences to see if it does anything. Any way to update the format and change it from "NA?"
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Provided everything you have told us is the complete picture, then a patch will be needed. That involves notification through your official support provider.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply