Filtering using OR ...

[adambc]

I've got 2 queries that separate out the records from a source file that satisfy ,,,

#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ((Record.Field(_, Table.ColumnNames(#"Changed Type"){6})) <> null) and ((Record.Field(_, Table.ColumnNames(#"Changed Type"){8})) <> null) and ((Record.Field(_, Table.ColumnNames(#"Changed Type"){9})) <> null))

... which works perfectly (all 3 conditions have to be satisfied) and ...

#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ((Record.Field(_, Table.ColumnNames(#"Changed Type"){9})) = null) or ((Record.Field(_, Table.ColumnNames(#"Changed Type"){8})) = null) or ((Record.Field(_, Table.ColumnNames(#"Changed Type"){6})) = null))

... which is causing me a problem!

If a record satisfies ((Record.Field(_, Table.ColumnNames(#"Changed Type"){9}))<> null) AND/OR ((Record.Field(_, Table.ColumnNames(#"Changed Type"){8})) <> null) - but satisfies the final test ie ((Record.Field(_, Table.ColumnNames(#"Changed Type"){6})) = null)), it is not picked up (the previous = null tests have failed and therefore not passed the record for the next test) ...

I've tried building 3 separate queries and then appending them, but I then don't have a field that I can use to Remove Duplicates (none of the records have a unique key field) ...

Is there another way to write my OR statement that I can use?

Or is there a different approach I can use?

Thanks ...

 

[adambc]

I've got 2 queries that separate out the records from a source file that satisfy ,,,

#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ((Record.Field(_, Table.ColumnNames(#"Changed Type"){6})) <> null) and ((Record.Field(_, Table.ColumnNames(#"Changed Type"){8})) <> null) and ((Record.Field(_, Table.ColumnNames(#"Changed Type"){9})) <> null))

... which works perfectly (all 3 conditions have to be satisfied) and ...

#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ((Record.Field(_, Table.ColumnNames(#"Changed Type"){9})) = null) or ((Record.Field(_, Table.ColumnNames(#"Changed Type"){8})) = null) or ((Record.Field(_, Table.ColumnNames(#"Changed Type"){6})) = null))

... which is causing me a problem!

If a record satisfies ((Record.Field(_, Table.ColumnNames(#"Changed Type"){9}))<> null) AND/OR ((Record.Field(_, Table.ColumnNames(#"Changed Type"){8})) <> null) - but satisfies the final test ie ((Record.Field(_, Table.ColumnNames(#"Changed Type"){6})) = null)), it is not picked up (the previous = null tests have failed and therefore not passed the record for the next test) ...

I've tried building 3 separate queries and then appending them, but I then don't have a field that I can use to Remove Duplicates (none of the records have a unique key field) ...

Is there another way to write my OR statement that I can use?

Or is there a different approach I can use?

Thanks ...

IGNORE - I've solved the problem with a helper column using my OR statement above ...