5 Replies Latest reply: Oct 30, 2017 3:25 PM by Sunny Talwar RSS

    Find distinct values from columns of loaded straight table.

    Ashish Palkar

      Hello

      Here are my scripts:

       

      TestTemp:

       

      LOAD * INLINE [
      F1, F2, F3
      1, a, 4234
      2, aaaa, 2342
      2, b, 24
      3, c, 34
      4, c, 64
      5, deee, 5345
      5, e, 6754
      5, e, 545
      ]
      ;

      Test:
      load Distinct
      F1,
      F2
      Resident TestTemp;

      Drop Table TestTemp;

       

      The result is:

      F1F2
      1a
      2aaaa
      2b
      3c
      4c
      5deee
      5e

      What I want is distinct F1. Create a KPI and show Distinct values of columns F1.

       

      So F1 value should be 1 2 3 4 5. Because F2 has two values for 2 and 5, 2 and 5 in F1 appeared twice.

      I want to only take the first value  in F2 as F2, so that the final result is

      F1F2
      1a
      2aaaa
      3c
      4c
      5deee

      How can I achieve that? Can anyone help please? Thanks!