4 Replies Latest reply: Dec 6, 2017 12:29 PM by Srinivas C RSS

    FieldValue in a table, for non distinct table column values

    Srinivas C

      Table:

      ColA    ColB

      A          A1

      B          B1

      C          A1

      D          A1

      E          C1

      F          B1

       

      When I do a FieldValue('ColB', 5) it is not returning anything. This is cos FieldValue takes distinct values of the column, and picking from that, pretty much defeating the column look up functionality.

       

      Is there any way to achieve this, using the values in ColB as they are and not eliminating duplicates.

       

      Wanted: FieldValue('ColB', 5) should return C1.

       

      Note: This is to be used in Charts, not on scripting side.