Forum Discussion
Remove Unwanted RANDOM Rows from Data
I have a list of tickets I am pulling from a ticketing system into Power BI using ODATA. The report I am building will be sent to a client each month and will need to be "Groomed" before sending.
Sometimes there is bad data/tickets that don't need to be in this report. There is no condition that I can power query off of as these will be one offs based off the monthly review.
I found a youtube video that worked but only seems to let me remove one row. I want to be able to remove multiple. Any suggestions.
I added an index column and then used advanced editor:
#"Added Index" = Table.AddIndexColumn(#"Sorted Rows", "Index", 0, 1, Int64.Type),
#"Remove Row" = Table.RemoveRows(#"Added Index",83)
in
#"Remove Row"
Anonymous received an error:
Error: Expression.SyntaxError: Token ',' expected.
#"Added Index" = Table.AddIndexColumn(#"Removed Top Rows", "Index", 0, 1, Int64.Type)
#"Remove Row" = Table.SelectRows(#"Added Index", each not List.Contains({4,5}, [Index]))
in
#"Remove Row"
4 Replies
Hi AmberJane
If you are sure which rows are unwanted by their Index numbers, you can try this
#"Remove Row" = Table.SelectRows(#"Added Index", each not List.Contains({1,3,4,83}, [Index]))Put all unwanted index numbers in a list {}.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!Anonymous received an error:
Error: Expression.SyntaxError: Token ',' expected.
#"Added Index" = Table.AddIndexColumn(#"Removed Top Rows", "Index", 0, 1, Int64.Type)
#"Remove Row" = Table.SelectRows(#"Added Index", each not List.Contains({4,5}, [Index]))
in
#"Remove Row"