= Table.TransformColumns(#"Added Custom1", {
{ "1", each if _ <> "" then 1 else 0, Int64.Type},
{ "2", each if _ <> "" then 1 else 0, Int64.Type},
{ "3", each if _ <> "" then 1 else 0, Int64.Type},
{ "4", each if _ <> "" then 1 else 0, Int64.Type},
{ "5", each if _ <> "" then 1 else 0, Int64.Type},
{ "6", each if _ <> "" then 1 else 0, Int64.Type},
{ "7", each if _ <> "" then 1 else 0, Int64.Type},
{ "8", each if _ <> "" then 1 else 0, Int64.Type},
{ "9", each if _ <> "" then 1 else 0, Int64.Type},
{ "10", each if _ <> "" then 1 else 0, Int64.Type},
{ "11", each if _ <> "" then 1 else 0, Int64.Type},
{ "12", each if _ <> "" then 1 else 0, Int64.Type},
{ "13", each if _ <> "" then 1 else 0, Int64.Type},
{ "14", each if _ <> "" then 1 else 0, Int64.Type},
{ "15", each if _ <> "" then 1 else 0, Int64.Type},
{ "16", each if _ <> "" then 1 else 0, Int64.Type},
{ "17", each if _ <> "" then 1 else 0, Int64.Type},
{ "18", each if _ <> "" then 1 else 0, Int64.Type},
{ "19", each if _ <> "" then 1 else 0, Int64.Type},
{ "20", each if _ <> "" then 1 else 0, Int64.Type},
{ "21", each if _ <> "" then 1 else 0, Int64.Type},
{ "22", each if _ <> "" then 1 else 0, Int64.Type},
{ "23", each if _ <> "" then 1 else 0, Int64.Type},
{ "24", each if _ <> "" then 1 else 0, Int64.Type},
{ "25", each if _ <> "" then 1 else 0, Int64.Type},
{ "26", each if _ <> "" then 1 else 0, Int64.Type},
{ "27", each if _ <> "" then 1 else 0, Int64.Type},
{ "28", each if _ <> "" then 1 else 0, Int64.Type},
{ "29", each if _ <> "" then 1 else 0, Int64.Type},
{ "30", each if _ <> "" then 1 else 0, Int64.Type},
{ "31", each if _ <> "" then 1 else 0, Int64.Type},
{ "32", each if _ <> "" then 1 else 0, Int64.Type},
{ "33", each if _ <> "" then 1 else 0, Int64.Type},
{ "34", each if _ <> "" then 1 else 0, Int64.Type},
{ "35", each if _ <> "" then 1 else 0, Int64.Type},
{ "36", each if _ <> "" then 1 else 0, Int64.Type},
{ "37", each if _ <> "" then 1 else 0, Int64.Type},
{ "38", each if _ <> "" then 1 else 0, Int64.Type},
{ "39", each if _ <> "" then 1 else 0, Int64.Type},
{ "40", each if _ <> "" then 1 else 0, Int64.Type},
{ "41", each if _ <> "" then 1 else 0, Int64.Type},
{ "42", each if _ <> "" then 1 else 0, Int64.Type},
{ "43", each if _ <> "" then 1 else 0, Int64.Type},
{ "44", each if _ <> "" then 1 else 0, Int64.Type},
{ "45", each if _ <> "" then 1 else 0, Int64.Type},
{ "46", each if _ <> "" then 1 else 0, Int64.Type},
{ "47", each if _ <> "" then 1 else 0, Int64.Type},
{ "48", each if _ <> "" then 1 else 0, Int64.Type},
{ "49", each if _ <> "" then 1 else 0, Int64.Type},
{ "50", each if _ <> "" then 1 else 0, Int64.Type},
{ "51", each if _ <> "" then 1 else 0, Int64.Type},
{ "52", each if _ <> "" then 1 else 0, Int64.Type}
})
No comments:
Post a Comment