Forum Discussion

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

Power Query Select Rows by position

Hi,    I was looking at selecting list items by positin but cuould not find much for Tables,   I came up wiht this  to retunr rows 1,3, 6 ,   List.Accumulate( { 0,2,5} , #table( {},{} ), ...
General Comment
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago
        Table.FromRecords(
        List.Transform(
            {0, 2, 5},
            (x) => SourceTable{x}
        )
    )
AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
2 years ago
    Table.FromRecords(
        List.Transform(
            {0, 2, 5},
            (x) => SourceTable{x}
        )
    )
Dicken's avatar
Dicken
Icon for Post Prodigy rankPost Prodigy
2 years ago

Just for context I was trying for a new way to select rows by  text criteria,  so and row with the word cat of dog, 

= List.Union( 
 List.Transform( 
Table.ToColumns( Source ), (A)=> 
  List.PositionOfAny( A, {"cat","dog"}, Occurrence.All) 
) )

 Table.FromRecords( 
 List.Transform( Positions, (A)=> 
   Source {A} ) )