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

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

Richad. 
 

General Comment
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago
        Table.FromRecords(
        List.Transform(
            {0, 2, 5},
            (x) => SourceTable{x}
        )
    )

3 Replies

  • 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} ) )
  • Dicken's avatar
    Dicken
    Icon for Post Prodigy rankPost Prodigy
    2 years ago

    Thanks, had not thought  of that, 

    Richard.