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:
And Table B has a value in the joining/key field of
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?
Thanks, that was an easy fix! I ended up having to do some manipulation to the data in Table B because it had values like '38' that needed to be '038' (always 3 digits). Do you know if there is a way to do that in the script while loading?