How to ignore Excel Query Errors

1
votes

I am using Excel's Power Query for data analysis. In the file that contains the original data, there are about 15 columns. The query is only pulling data based on one of the columns. For example, the column contains either 'A' or 'B'. I want all data of that row if that certain column is a 'B'.

Example of my Excel data

The problem is in Column A, all of the names are text except for row 5. It's a decimal. Excel Power Query will throw an error and say it doesn't match the other rows. It will still query the data and pull it into another file, but with throwing the errors.

Some of my data will not match like in this example. So is there a way to ignore these errors? I still want the data from the original file; I just want to tell Excel that it's okay if the row data doesn't match other rows. I've formatted the entire column to one type and that doesn't seem to solve the problem.

1
excelpowerquery
Can't recreate this error from that data - a decimal can be read as a text value with no errors. Edit your post to include your code which causes an error with that sample data. – Olly

1 Answers

1
votes

You can use Table.RemoveRowsWithErrors to remove the rows that have errors, or Table.ReplaceErrorValues if you want to replace the error value in the cell with something else.