Step20 = Table.AddColumn(#"Changed column type", ".CustValidNum", each if Text.Length([CUST_SALES])=Text.Length(Text.Select([CUST_SALES],List.Transform({0..9},each Number.ToText(_)))) then "V" else "I"),
Step21 = Table.SelectRows(Step20, each [#".CustValidNum"] = "V"),
Step22 = Table.TransformColumnTypes(Step21, {{"CUST_SALES", Int64.Type}})
in
Step22
No comments:
Post a Comment