Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Data type in Table.TransformColumns

Hi, I found out recently that function Table.TransformColumns lets you specify a 3rd parameter to identify the data type of the transformed column. However that parameter doesn't seem to react the wa...
General Comment
JasonTX's avatar
JasonTX
Resolver I
6 years ago

You want to refer to the column rather than each record. Refer to below. To my understanding, the third paramater is used to handle null values.

 

let
Source = Table.FromColumns({{1,2,3}}, {"Test"}),
#"Transform column" = Table.TransformColumns(Source, {"Test", Number.From})
in
#"Transform column"