Two tables field value to check

[chiragngohel]

Hi,

Can someone help me please?

I am trying to compare two file fields value with same field name(comparison for two months) in script.

Can some one suggest best way? Is it possible?

FOR i = 1 to NoOfFields('T')
Concatenate

Fields:

LOAD

// FieldName($(i),'New') as FieldName
FieldName($(i),'T') as F,
FieldValue($(i),'T') as v,
//FieldValue(FieldName($(i),'T')) as F2,
//if(FieldName like FieldName($(i),'New') and FieldValue=FieldValue,'Match','Others') as t2,
if(WildMatch(FieldName($(i),'T'), FieldName($(i),'T2')),'Match','Other') as f1,
if(Match(FieldValue($(i),'T'),FieldValue($(i),'T2')),'Match','Other') as f3

AutoGenerate 1

;
NEXT I

[chiragngohel]

Name	total
a	20
b	30
c	40
d	50

[chiragngohel]

these are the two tables I am trying to compare the fields name and its value.

I hope it make sense now.

[settu_periasamy]

That is fine. Can you give the expected result?