comparing 1 column with no of columns

[krishnagutha1294]

Hi All

I have 2 tables 

Table 1:

A,B,C

Table 2:

D,E,F,G,H

Now I need to calculate Count(A)

When A=D or A=E or A=F

Please can any one help how to resolve 

Thanks in advance 

[Taoufiq_Zarra]

in Script or UI ?

can you share a sample data and the expected ?

[krishnagutha1294]

In Script

[sunny_talwar]

Something like this?

Table2:
LOAD * INLINE [
    D, E, F, G, H
    10, 20, 30, 10, 50
    100, 10, 20, 20, 30
    50, 40, 40, 60, 40
    10, 30, 50, 40, 60
];

Table1:
LOAD * INLINE [
    A, B, C
    10, 50, 30
    40, 20, 20
];

CountTable:
LOAD Count(If(Exists(D, A), A)) as A_D,
	 Count(If(Exists(E, A), A)) as A_E,
	 Count(If(Exists(F, A), A)) as A_F
Resident Table1;