Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
Hi,
I dont know wht is ESTAOID but maybe this can help you:
sum(if(ID_ORDEN_IND=ID_ORDEN_TEM,1,0))
Regards.
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.