Expression to compare to fields in a table

[#1]

Hello,

I have a table with two fields ID1, ID2.

I’m looking for an expression to find all entries where ID1 <> ID2.

In the following inline, I would like to ‘earmark’ rows 3,17.

t:
load
RowNo() as RowId,
*
;
LOAD * INLINE [
ID1, ID2
1, 1
2, 2
3, 2
4, 4
5, 5
6, 6
7, 17
8, 8
9, 9
];

Thanks,

Shaul

[#2]

Thanks!

[preminqlik · Accepted solution]

hi there,

use this expression in chart !

only({<ID1={'=ID1<>ID2'}>}ID2)

find the attachment

[#4]

Quick follow up to this...what if the fields were in 2 different tables?  What is an expression that would return any value in either table/field that is not a value in the the first table/field?

In other words, just list every value that is in one field but not in the other field...for both fields.

(not using a load script as this could be done there with where not exists)

Looking for an expression.

Thanks.