Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Name | total |
a | 20 |
b | 30 |
c | 40 |
d | 50 |
these are the two tables I am trying to compare the fields name and its value.
I hope it make sense now.
That is fine. Can you give the expected result?