3 Replies Latest reply: Feb 10, 2012 3:20 PM by Henric Cronström RSS

    Join two tables on text field

      I am trying to join/associate two tables on a field that contains text values that look like numbers.

       

      For example, Table A might have the following values in the joining/key field:

      '128'

      '128.'

      '128.0'

       

      And Table B has a value in the joining/key field of

      '128'

       

      When I join Tables A and B, I want the value from Table B to only join to the 1st value listed in Table A above.  Qlikview seems to be treating the three values in Table A listed above as the same value (numerically = 128).  Any ideas on how to make sure QlikView treats those three values as distinct text values?