field value comparision

[AjithramT]

I just want to know is there any possibilities to check the particular field's each value by the other fields value(one by one).

what I try to convey is,

for ex: now I have two fields,

A   B

3   4

4  3

5  2

2   5     

Now, each Value of A should go and check with each value of b (3(1st val of A) should go and check with every value of B).

Through this, I'll create the next Field 'C' (if the

value of A=Value Of B, then it should not come in the field C).

Thanks ,

Ajith

[Shubham_Deshmukh · Accepted solution]

Hi Ajit,

Check the below code,

Table1:

LOAD * Inline [

A, B

10, 10

2, 20

3, 30

];

Table2:

LOAD if(Exists(A,B),'',B) as newCheck,A,B
Resident Table1;

Rgds,

Shubham