Description of format results from Column Analysis
Description of format results from Column Analysis
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.
EDIT:
Data Class: Text
Properties: String
Format > General Format: NA
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
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
Robert
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: