Consumption Analytics Documentation

Home > Documentation for older versions > Cloud Cruiser 4 > Administering > CCIMPORT and CCEXPORT reference > Lookup table CSV file format

Lookup table CSV file format

This article specifies the format of a CSV file that is required to import lookup tables with ccimport and written by ccexport.


The first line of the file is a header row that defines the format of the subsequent rows. The following table describes the valid field names for the header row, some of which also have short names that you can use instead. In the full field names, you can substitute dots (.) for underscores (_).

CSV rows beginning with a pound sign (#) are treated as comments and ignored by the importer.

Handling special characters


Field Name



pattern An exact pattern to match. When matched, targetValue is returned. Takes precedence over lowId and highId. No
lowId The low end of a range to match. When a source value is between this value and highId, inclusive, targetValue is returned. No
highId The low end of a range to match. When a source value is between lowId and this value, inclusive, targetValue is returned. No
targetValue The value to return if the row is matched. Yes

Sample CSV

The following is a sample CSV file.

Last modified



This page has no classifications.

 (c) Copyright 2017-2020 Hewlett Packard Enterprise Development LP