12 Replies Latest reply: Apr 13, 2016 12:39 PM by Settu Periyasamy RSS

    Two tables field value to check

    Gohel Chiragkumar

      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