Forum Discussion

LON's avatar
LON
Icon for Helper I rankHelper I
9 years ago
Solved

Handling Empty Results

Hi   I have a query which returns a list of issues in jason format which I then transform into a table and visualize.  The problem is when no rows are returned i.e. no issues - so then there is no ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    LON,

    Change your code as follows. And maybe you would need to change List.IsEmpty(content) part in the following code to List.IsEmpty(Source) or List.IsEmpty(body), you can test it.

    let

Source = Json.Document(Web.Contents("https://xxxxxxxxxxxxx", [Headers=[zzzzz="xxxxxx"]])),
body = Source[body],
content = body[content],
#"Converted to Table" = Table.FromList(content, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
Table1=Table.FromRecords({
        [Column1 = ""]
        
    }),
     result= if List.IsEmpty(content) then Table1 else #"Converted to Table" 
in
     result



    Regards,

Anonymous's avatar
Anonymous
Not applicable
9 years ago

LON,

Change your code as follows. And maybe you would need to change List.IsEmpty(content) part in the following code to List.IsEmpty(Source) or List.IsEmpty(body), you can test it.

let

Source = Json.Document(Web.Contents("https://xxxxxxxxxxxxx", [Headers=[zzzzz="xxxxxx"]])),
body = Source[body],
content = body[content],
#"Converted to Table" = Table.FromList(content, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
Table1=Table.FromRecords({
        [Column1 = ""]
        
    }),
     result= if List.IsEmpty(content) then Table1 else #"Converted to Table" 
in
     result



Regards,

LON's avatar
LON
Icon for Helper I rankHelper I
9 years ago

Thanks very much for al your help with this - very much appreciated.

 

Best Regards

 

Liam