0 Replies Latest reply on Nov 16, 2020 11:13 PM by Prasanna Maniyur

    Compare column 1 data with column 2 (comma separated) data

    Prasanna Maniyur New Member

      Trying to compare the column 1 data with column 2 (comma separated) in expression to derive the status.

       

      Note: Comparison is not case-sensitive and entire col1 should match exactly with Col2, see row3

      Example
      IDCol 1Col 2
      1onon,off,set
      2OFFno,test,off
      3netnetwork,indnet
      4testdelta, exp
      Expected Output
      IDCol 1Col 2IsCol1DataExistsInCol2
      1onon,off,set1
      2OFFno,test,off1
      3netnetwork,indnet0
      4testdelta, exp0