Forum Discussion
Displaying rows with non-duplicate values
I am trying to create a query/table that will only display the rows that have different values for certain colums. I need to identify which cases have a different pathologic diagnosis before and after surgery along with the corresponding assesion number. Table looks something like this
Column 1 Column 6 Column 7 Column 10 Column 11
Assession # Pre-Op Diagnosis PreOp Tumor Type Post-Op Diagnosis Post-Op Tumor Type etc.
SMM18-001 BCC nodular BCC Nodular
SMM18-002 BCC infiltrative BCC Nodular and Superficial
I have searched online for an reasonable answer to solve this but have not been able to locate anything. Any assistance would be greatly appreciated.
So add a custom column in Power Query. It will be something like
= if [column 6] = [column 10] and [column 7] = [column 11] then “Same” else “not same”
then filter the new column.
Make sure you use use the custom column UI to get the right capitalisation of the column names.
3 Replies
Which columns? In Power Query you can create a custom column to test if values in 2 columns are the same, and return true or false, then filteron that column.
Columns 6 + 7 compared to 10 + 11
So add a custom column in Power Query. It will be something like
= if [column 6] = [column 10] and [column 7] = [column 11] then “Same” else “not same”
then filter the new column.
Make sure you use use the custom column UI to get the right capitalisation of the column names.
