Forum Discussion

Dom33's avatar
Dom33
Regular Visitor
9 years ago
Solved

Managing Errors in M-Language Query (Advanced Editor)

HI, Input data are in a json file like that: {     "lastname":{         "columns_found":2,         "columns":[             {                 "location":"['Table1'].['DESCRIPTION']",          ...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    Replace the first null in #"Converted to Table" by 1:

     

        #"Converted to Table" = Table.FromList(columns, Splitter.SplitByNothing(), 1, null, ExtraValues.Error),

     

    This will force the table to be created with 1 column.

MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

Replace the first null in #"Converted to Table" by 1:

 

    #"Converted to Table" = Table.FromList(columns, Splitter.SplitByNothing(), 1, null, ExtraValues.Error),

 

This will force the table to be created with 1 column.

  • Dom33's avatar
    Dom33
    Regular Visitor
    9 years ago

    Hi Marcelbeug,

    It's work fine, thanks a lot ! :smileyhappy: