Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter and only keep list

Working with json, a column gives mixed data. How can I isolate the "List"s from the remaining lines? One way is to unselect all in the filter. It works for some reason, but is not dynamic. I've tried putting null, [List] and "", but was not succesful. Also is there a specific name/term for this "List"? 

Intended result:

Data from AZURE Cognitive Service

Need Help

2 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    5 years ago

    =Table.SelectRows(#"Changed Type",each [Value] is list)

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    Based on your pic, you can now add an Index column, then a Modulo column, and then filter to just the rows with the Lists.

     

    Or you can provide some of the JSON text, so a specific solution can be provided.

     

    Pat