detectColumnTypesAndNumberFormats
detectColumnTypesAndNumberFormats(
dataRows,columnIDs):object
Detect the SQL types and number formats of the given columns of the given matrix
Parameters
Section titled “Parameters”dataRows
Section titled “dataRows”columnIDs
Section titled “columnIDs”string[]
Returns
Section titled “Returns”object
the detected data types (and number formats, when applicable), defaulting to DataType.text if no clear type is found
columnTypes
Section titled “columnTypes”columnTypes: (
"string"|"number"|"boolean"|"datetime"|"date"|"timeofday")[]
numberFormatByColumnIdLower
Section titled “numberFormatByColumnIdLower”numberFormatByColumnIdLower:
Map<string,string>