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

[jagan]

Hi,

Try like this

t:
load
RowNo() as RowId,
*,

If(ID1 <> ID2, 1, 0) AS Flag
;
LOAD * INLINE [
ID1, ID2
1, 1
2, 2
3, 2
4, 4
5, 5
6, 6
7, 17
8, 8
9, 9
];

Now in set analysis you can use flag field to find count() or sum().

=Count({<Flag={1}>} ID1)

Hope this helps you.

Regards,

Jagan.

[jonathandienst]

Hi

To filter:

t:

load

  RowNo() as RowId,

  *

where ID1 <> ID2

;

LOAD * INLINE [

    ID1, ID2

    1, 1

    2, 2

    3, 2

    4, 4

    5, 5

    6, 6

    7, 17

    8, 8

    9, 9

];

To flag matches/mismatches:

t:

load

  RowNo() as RowId,

  *,

  If(ID1 = ID2, 1, 0) As MatchFlag

;

LOAD * INLINE [

    ID1, ID2

    1, 1

    2, 2

    3, 2

    4, 4

    5, 5

    6, 6

    7, 17

    8, 8

    9, 9

];

HTH

Jonathan

[its_anandrjs]

Hi,

Try this ways

load
RowNo() as RowId,
if(ID1=ID2,'Match Record','UnMatch Record') as IdDetails, //For Finding flag (Match and MisMatch)
if(ID1=ID2,1 , 0 ) as Flag //For SET analysis calculation
*;
LOAD * INLINE [
ID1, ID2
1, 1
2, 2
3, 2
4, 4
5, 5
6, 6
7, 17
8, 8
9, 9
];

Regards

Anand

[#5]

Thanks for the tip Jonathan. What I am looking for is a Chart/Expression solution as opposed to a Scripting one. I was wondering if it is doable to compare two columns in a  QV  chart. Thanks! Shaul

[#6]

Thanks for the tip Anand. What I am looking for is a Chart/Expression solution as opposed to a Scripting one. I was wondering if it is doable to compare two columns in a  QV  chart. Thanks! Shaul

[#7]

Thanks for the tip Jagan. What I am looking for is a Chart/Expression solution as opposed to a Scripting one. I was wondering if it is doable to compare two columns in a  QV  chart. Thanks! Shaul

[#8]

try

where not exists(ID1,ID2)

[#9]

ahhhh.

then in the chart write an expresson like this

=IF(ID1<>ID2, whateveryouwant2returniftheymatch)

notice that I didn't include else.

[rwunderlich]

Wouldn't that just be an expression:

ID1 <> ID2

Or is it more complex than that?

-Rob