Forum Discussion

anshpalash's avatar
anshpalash
Helper II
4 years ago
Solved

Data Cleaning

Hi,   I have a dataset in the form. 1 null Start: 7:20 null null Duration: 3 null End:10 1 null null null null null null null 1 null null null null null null null ...
Need Help
  • Syndicate_Admin's avatar
    Syndicate_Admin
    4 years ago

    You can this step to your query.

    = Table.FromRows( List.RemoveNulls( List.Transform(Table.ToRows(PriorStepName), each let l=List.RemoveNulls(_) in if List.Count(l)>1 then l else null) ), {"ID","Start","Duration","End"} )

    Result

    Jakinta_0-1632940649523.png

     

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

You can this step to your query.

= Table.FromRows( List.RemoveNulls( List.Transform(Table.ToRows(PriorStepName), each let l=List.RemoveNulls(_) in if List.Count(l)>1 then l else null) ), {"ID","Start","Duration","End"} )

Result

Jakinta_0-1632940649523.png

 

anshpalash's avatar
anshpalash
Helper II
4 years ago

Thank you so much!