Int32.Type is a type facet in the Power Query M language. It represents one of the type claims belonging to ‘type number’. It is used for handling common integer values in various data processing and storage operations. The base type of ‘type number’ in Power Query is a general numeric type, but facets like Int32.Type provide additional details (such as representing 32-bit integers) for improved data handling in external systems.
Examples
Generally, you will face a facet when transforming column types. You can transform a column into the specified type by using Table.TransformColumnTypes:
Table.TransformColumnTypes( Source, {{ "myColumn", Int32.Type }} )
Or when adding a column using Table.AddColumn:
Table.AddColumn( Source, "myColumn", 99, Int32.Type" )
To inspect the kind of value you are dealing with, you can make use of the Table.Schema function. Applying it to a table returns a table with information about your columns. The Table.SingleRow function then transforms the result into a record, for easier reading.
let
a = 99,
// Ascribes a type claim facet for 'type number'
b = Value.ReplaceType( a, Int32.Type ),
// Returns a table containing a value with the ascribed "Int32.Type"
c = #table(type table [Col1 = Value.Type( b ) ], { b } ),
// Shows the Table information, including typeName and value kind
d = Table.Schema( c ),
// For easier viewing, return table as record
e = Table.SingleRow( d )
in
e
Related facets
Other related facets are:
- Any.Type
- Binary.Type
- Byte.Type
- Character.Type
- Currency.Type
- Date.Type
- DateTime.Type
- DateTimeZone.Type
- Decimal.Type
- Double.Type
- Duration.Type
- Function.Type
- Guid.Type
- Int16.Type
- Int64.Type
- Int8.Type
- List.Type
- Logical.Type
- None.Type
- Null.Type
- Number.Type
- Password.Type
- Percentage.Type
- Record.Type
- Single.Type
- Table.Type
- Text.Type
- Time.Type
- Type.Type
- Uri.Type
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy