Forum Discussion
Try Otherwise in M (Error Replacement)
Hello,
I got a question. I got a lot of errors because the date field is empty. So I thought a error handling with try otherwise could help me out but how can I implement it? (I just put in 1 column for example.) Maybe someone can give me a hint.
let
Quelle = Csv.Document(File.Contents("\\file\file.csv"),[Delimiter=";", Columns=161, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Höher gestufte Header" = Table.PromoteHeaders(Quelle, [PromoteAllScalars=true]),
#"Geänderter Typ" = Table.TransformColumnTypes(#"Höher gestufte Header",{{"Zahlungsdatum", type date}}),
#"Error Date" = Try (#"Geänderter Typ",{{Zahlungsdatum", type date}}) Otherwise Error ""
in
#"Error Date"
4 Replies
Anonymous,
Please change your code to the following:let Quelle = Csv.Document(File.Contents("\\file\file.csv"),[Delimiter=";", Columns=161, Encoding=1252, QuoteStyle=QuoteStyle.None]), #"Höher gestufte Header" = Table.PromoteHeaders(Quelle, [PromoteAllScalars=true]), #"Geänderter Typ" = Table.TransformColumnTypes(#"Höher gestufte Header",{{"Zahlungsdatum", type date}}), #"Added Custom" = Table.AddColumn(#"Geänderter Typ", "Custom", each try Date.From([Zahlungsdatum]) otherwise null) in #"Added Custom"
Reference:
https://blog.gbrueckl.at/2013/12/error-handling-in-power-query/
Regards,
LydiaAnonymous
Is there a possibility to make a Table.TransformColumns instead of Table.AddColumn ?
#"Error Date" = Table.TransformColumns(#"Geänderter Typ", each try Date.From([Rezeptdatum]) otherwise null)
#"Error Date" = Table.TransformColumns(#"Geänderter Typ", {{"Rezeptdatum", each try type date otherwise null}})