If Otherwise error

Question

Hi,I have below line:&nbsp;= Table.TransformColumnTypes(#"Filtered Rows",{{"userId", Int64.Type}})&nbsp;this changes column to whole numbers, on some lines this drops errors. I have tried below&nbsp;= try Table.TransformColumnTypes(#"Filtered Rows",{{"userId", Int64.Type}}) otherwise null&nbsp;but it doesn't work. It still shows errors.&nbsp;What I would like achieve is:&nbsp;convert to whole numbers, if error leave as text&nbsp;thanksdan

jimmy801 · Accepted Answer

Hello Anonymous&nbsp;&nbsp;this is because Table.TransformColumnTypes is applied at once. When you get an error means that the content isn't suitable for the change. However this means the column type can't be changed - only on cell level. This can be achieved by applying a TransformColumns only. See here an examplelet
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSK1YlWMgKTxmAyMSkZTOvqgqmS1OISpdhYAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Number = _t]),
    TransformColumn =Table.TransformColumn
    (
        Source,
        {
            {
                "Number", each try Number.From(_) otherwise _, type any
            }
        }
    )
in
    TransformColumnCopy paste this code to the advanced editor to see how the solution works&nbsp;If this post helps or solves your problem, please mark it as solution.Kudos are nice to - thanksHave funJimmy

Forum Discussion

If Otherwise error

2 Replies

Related content

Try Otherwise in M (Error Replacement)

try... otherwise do not execute the otherwise clause in Web.Contents function

IF SelectedValue is Blank, Blank, otherwise check if Number, otherwise output...

error message

network error