在 Power BI 中将文本列“Column1”中的模式提取到另一列“Release”时,如果“Column1”列具有空值或 null 值,我会收到错误消息。我有下面的代码,适用于非空值,但如果“column1”单元格为空或为空,则会出现错误。我想跳过空列值和空列值。如何解决这个问题?
let
Source = Excel.Workbook(File.Contents("C:\Users\aditya\Documents\Test.xlsx"), null, true),
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Sheet1_Sheet,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}}),
#"Added Release" = Table.AddColumn(#"Changed Type", "Release", each let a = List.Transform(Text.Split([Column1], ";"), each Text.Trim(_)),
b = List.Select(a, each Text.StartsWith(_,"R") and Value.Is(Value.FromText(Text.At(_, 1)), type number))
in b{0}?)
in
#"Added Release"
Text.Split
该步骤中的功能失败#"Added Release"
。将 null 转换为
""
这样它就不会在Text.Split
函数上失败:然后你需要添加空检查: