count matching

[Anonymous]

hi,

ı have a very simple question, that you might all know

ı have 2 tables

a , b

x , a

x , a

y , b

   , c

   , d

ı want to distinct count values in table b but only the matching ones ( a ,b)

when a basicly count(distinct ) values in table b, it counts all the values (a,b,c,d) but ı want just the matching ones with table a.

(the two tables are joined, no prblm)

thnks for any helps.

[oknotsen]

How about something like this:

=count( { < SomeField = SomeOtherField> } distinct SomeField)

[Anonymous]

It does not solve.

The Two tables are already joined.

table a , table b

ID          ID    ID2

x ,          x ,   a

x ,          x,    a

y ,          y,    b

              z  ,  c

              t    , d

ı need the distinct count of column ID2 (matching ones)

[Anonymous]

Any helps?

[#5]

If i understood your logic you need count result as 2 isn't it? or else

[anbu1984 · Accepted solution]

T1:

Load *,ID As ID_Cpy Inline [

ID

x

x

y

];

T2:

Load * Inline [

ID , ID1

x , a

x , a

y , b

   , c

   , d ];

=Count(DISTINCT If(Not(IsNull(ID_Cpy)),ID1))

[anbu1984]

T1:

Load *,ID As ID_Cpy Inline [

ID

x

x

y

];

T2:

Load * Inline [

ID , ID1

x , a

x , a

y , b

   , c

   , d ];

=Count(DISTINCT If(Not(IsNull(ID_Cpy)),ID1))

[Anonymous]

=Count(DISTINCT If(Not(IsNull(ID_Cpy)),ID1))

that was all I need.

Thank you very much my friend.

for your help.