Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0711

...

Info

NOTE: Mapping source data types to

D s item
itemdata types
depends on a sufficient number of values that match the criteria of the internal data type. The mapping of import types to internal data types depends on the data.

  • Type inference needs a minimum of 25 rows of data in a column to work consistently.

  • If your dataset has fewer than 20 rows, type inference may not have sufficient data to properly infer the column type.

In some datasets, the first 25 rows may be of a data type that is a subset of the best matching type. For example, if the first 25 rows in the initial same match the Integer data type, the column may be typed as Integer, even if the other 2,000 rows match for the Decimal data type. If the column data type is unmodified, the data is written out from

D s product
as Integer data type. At least the other 2,000 rows are written out as null values, since they do not match the Integer data type. If the source data used decimal notation (e.g. 3.0 in the source), then those values are written out as null values, too.

...

  • The application maps the internal 
    D s item
    itemdata type
     to the explicit type listed in the appropriate page in this section.
  • Unmapped types are converted to the equivalent of strings.

Tip

Tip: You can import a target schema to assist in lining up your columns with the expected target. For more information, see Overview of RapidTarget.

D s item
itemdata types
:

D generate child excerpts
pagesSupported Data Types
heading2
linktrue

...