Column mapping types

Data Manager formats raw data using a number of different column types that help to describe the kind of information that becomes an attribute. When importing information from a general data source such as a flat file or a CSV, you may need to use the Set column type transform on that data source to change the format of a field so that you can sort and filter on this information later.

データ マネージャーでは、次の列タイプを使用できます。

• String – contains data in a string format, such as a name Robert Paulson or a serial number SN/395385A345. This field can contain a maximum of 255 characters.

• Date – contains data formatted as a date. Because there are multiple date formats available, if you are mapping a date column, make sure you use the date format dropdown to select the date format of the source information.

• Integer – contains a whole integer number, such as 21 or 119548.

• Big Int – contains a very long whole integer number, such as 8454547333056.

• Decimal – contains a number including a decimal (sometimes known as Float), such as 4863.006.

• Boolean – contains a yes or no value, expressed as a digital 1 or 0.Accepted values for true: t, y, 1, yes, true.Accepted values for false: f, n, 0, no, false.