Forum Discussion

mosarahit48's avatar
mosarahit48
Frequent Visitor
3 years ago
Solved

Removing Unwanted Rows Dynamically

How to remove unequal numbers of "Top" & "Bottom" rows (together) dynamically from multiple files in Power Query?

  • ppm1's avatar
    ppm1
    3 years ago

    Is there a value in a column that is only in the top/bottom rows you want to skip. If so, you can just do a filter. You can also use Table.Skip, which can be used with a condition to dynamically skip rows You would do this in the #"Transform sample file" query (or a custom function) so that it gets applied dynamically to each file.

     

    Table.Skip - PowerQuery M | Microsoft Learn

     

    Pat

     

2 Replies

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    Is there a value in a column that is only in the top/bottom rows you want to skip. If so, you can just do a filter. You can also use Table.Skip, which can be used with a condition to dynamically skip rows You would do this in the #"Transform sample file" query (or a custom function) so that it gets applied dynamically to each file.

     

    Table.Skip - PowerQuery M | Microsoft Learn

     

    Pat