Forum Discussion
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...
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"