Forum Discussion

Dicken's avatar
Dicken
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

M code nullable values

  Hi,  I have a simple two column table a = text b = numbers,    i have added two columns ,  Table.AddColumn( Source, "N", each Type.IsNullable( Value.Type( [B] ))) I have been trying to use T...
Need Help
  • ronrsnfld's avatar
    ronrsnfld
    2 years ago

    To return columns of type number, try:

    Table.ColumnsOfType(Source,{type nullable number})
ronrsnfld's avatar
ronrsnfld
Icon for Super User rankSuper User
2 years ago

Also note you can determine whether a column type is nullable or not by inspecting the isNullable column of the output from Table.Schema

  • Dicken's avatar
    Dicken
    Icon for Post Prodigy rankPost Prodigy
    2 years ago

    Yes, I have a question re schema, but I need to work  to get  put an example together, 

    but thanks for  repsonding.