Forum Discussion
Solved
Find unique value in two columns
How do I check for two columns in a single table to see if they match? I need to create a column labeled "Check" to find ID where type A maches type B. TIA
| ID | Type | Check |
| 1 | A | TRUE |
| 2 | A | TRUE |
| 3 | A | TRUE |
| 4 | A | TRUE |
| 5 | A | FALSE |
| 6 | A | FALSE |
| 1 | B | TRUE |
| 2 | B | TRUE |
| 3 | B | TRUE |
| 4 | B | TRUE |
lpd82 , Try a new column like
new column =
var _id = [ID]
var _Ty = [Type]
var _1 = countx(filter(Table, [ID] = _id && [Type] <> _ty),[ID)
return
if(isblank(_1), False(), True())
2 Replies
lpd82 , Try a new column like
new column =
var _id = [ID]
var _Ty = [Type]
var _1 = countx(filter(Table, [ID] = _id && [Type] <> _ty),[ID)
return
if(isblank(_1), False(), True())Perfect! Thank you.
