Importing files for reference data sets (Watson Knowledge Catalog)

You can create reference data sets outside of the catalog in CSV (comma-separated value) format, then import or reimport values. You can also import value-mapping relationships between values in multiple reference data sets.

The CSV import file at a minimum consists of the following columns that are defined for the reference data set:

  1. Code
  2. Value
  3. Description (optional)
  4. Parent (optional)

For example, the first several rows of a reference data set for NAICS codes look like this:

Code,value,description,parent
11,Agriculture, Forestry, Fishing and Hunting
111,Crop Production,Crop Produ,11
1111,Oilseed and Grain Farming,111
11111,Soybean Farming,Soybean Farming,1111
111110,Soybean Farming,Soybean Farming,1111
11112,Oilseed (except Soybean) Farming,Oilseed (except Soybean) Farming,1111
111120,Oilseed (except Soybean) Farming,Oilseed (except Soybean) Farming,1111

Importing files

Click Add file to select a CSV file from which to import values for the reference data set that you want to define:

Custom columns

You can map columns in a reference data set from a CSV file to existing custom columns or to new custom columns that you create.

Values in a reference data sets by default have three columns: code, value, and description. However, you might want to capture additional information related to the code such as translations of the value in different languages or other supportive attribute information relevant to your needs. For example, you might have a reference data set of country codes and want to capture some other attributes like prime minister of the country, language, or alternative names.

You can add custom columns during the creation of a reference data set or during a reimport of values from a CSV file into a reference data set. See the following example of a portion of a CSV file for custom columns.

code,value,description,Capital City,National Day,Official Language,Population
AFG,Afghanistan,The Islamic Republic of Afghanistan,Kabul,19/08/1919,دری,37200000
ALA,Åland Islands,Åland,Mariehamn,07/05/1920,svɛ̂nːska,28007
ALB,Albania,The Republic of Albania,Tirana,28/11/1912,Albanian,2850000
DZA,Algeria,The People's Democratic Republic of Algeria,Algiers,05/07/1962,الجزائر‎,42200000
ASM,American Samoa,The Territory of American Samoa,Pago Pago,14/06/1889,English,55465

Note: Reference data sets with values up to a maximum of 5K are supported.

Learn more