Power Query Select Rows by position

[Dicken]

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( {},{} ),
        (S,C)=> S &  Table.Range( SourceTable , C, 1)  ) 

Just wondered if there were other ways or functions to do this? 

Richad. 
 

[Dicken]

Thanks, had not thought  of that, 

Richard. 

[AlienSx · Accepted solution]

    Table.FromRecords(
        List.Transform(
            {0, 2, 5},
            (x) => SourceTable{x}
        )
    )

[Dicken]

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} ) )