Comparing same column from different tables...

[charlesdmeyer]

I have two sets of student testing data.  One from the Fall, one from the Winter.  They have the exact same column names.  I want to compare a student's score on Fall test to Winter test.

Is there a way to create an equation to look at Goal 1 for Fall and compare to Goal 1 for Winter.

I know that is vague but I hope someone knows.

[Anil_Babu_Samineni]

The way, I can think this way?

Load Field1, Field2, Field3, 'T1' as Flag From T1;

Load Field1, Field2, Field3, 'T2' as Flag From T2;

Then, think about this way?

If(Sum({<Flag={T1}>} Field3)=Sum({<Flag={T2}>} Field3), 1, 0) as Final_Flag