Compare two fields

[#1]

Hello,

I have 2 fields

ID_ORDEN_IND      and
ID_ORDEN_TEM

Both contain a sequence of numbers , for example : 445566

I would like to know how many ID are repeated each other ... something like the following:

If ID_ORDEN_IND = ID_ORDEN_TEM , COUNT ( ESTADOID )

But not how to translate it into an expression paragraph get the calculation.

I hope you can help me, thanks in advance.

[swuehl]

Where does field ESTADOID come from?

You can do the analysis like this:

LOAD ID_ORDEN_IND as TestID,

          'IND' as Source

FROM YourIndIDSource;

LOAD ID_ORDEN_TEM as TestID,

          'TEM' as Source

FROM YourTemIDSource;

Now you can create a chart with TestID as dimension and

=Count(Distinct Source)

as expression. Sort by expression descending shows all duplicate IDs on top.

You create an overall count like

=Count({<TestID = {"=Count(Distinct Source)=2"}>} Distinct TestID)

[Anonymous]

Hi,

I dont know wht is ESTAOID but maybe this can help you:

sum(if(ID_ORDEN_IND=ID_ORDEN_TEM,1,0))

Regards.

[gilbertomedeiro]

Hello Guerreiro,

It is your expression, right? 

If ID_ORDEN_IND = ID_ORDEN_TEM , COUNT ( ESTADOID )

So, I try rewrite it:

COUNT(DISTINCT IF(ID_ORDEN_IND = ID_ORDEN_TEM, ESTADOID))

By the way, in my opinion, Giuseppe is right too.

Regards.