topic Re: Data Linkage - Text/Number Formating in QlikView

Data Linkage - Text/Number Formating

Fri, 06 Dec 2013 14:22:03 GMT

Hi,

I'd like to link two tables together by Part Number. The Part Number can both in a number(1234) or text(002H32) format. How should I specify only a Text match, which means for example I don't want to loose "0"s in front of my text? Thanks!

Re: Data Linkage - Text/Number Formating

Anonymous — Fri, 06 Dec 2013 14:25:41 GMT

Try use text([Part Number])

Re: Data Linkage - Text/Number Formating

a_mullick — Fri, 06 Dec 2013 14:37:32 GMT

QlikView shouldn't drop any leading zeros: it loads what it is given. As long as you ensure that any leading zeros are preserved in the source data, it should be ok. If you load this simple example, you'll see that the 'key' links the 2 tables even though it has different formats.

load * inline [

key, data

001x, 12

abcd, 14

1122, 10

];

load * inline [

key

001x

abcd,

1122

];

Azam

Re: Data Linkage - Text/Number Formating

Anonymous — Fri, 06 Dec 2013 14:51:30 GMT

Azam,

Your example works because it is incomplete. Try this, see that 12 and 0012 are the same for QV (001x is text because of "x"):

t1:
load * inline [
key, data
001x, 12
0012, 40
abcd, 14
1122, 10
];

t2:
load * inline [
key, test
001x, a
0012, b
12, c
abcd, d
1122, e
];

This works correctly:

t1:
load text(key), data inline [
key, data
001x, 12
0012, 40
abcd, 14
1122, 10
];

t2:
load text(key), test inline [
key, test
001x, a
0012, b
12, c
abcd, d
1122, e
];

Regards,

Michael

Re: Data Linkage - Text/Number Formating

a_mullick — Fri, 06 Dec 2013 15:04:38 GMT

Ah...thanks for pointing that out.

Azam

Re: Data Linkage - Text/Number Formating

Fri, 06 Dec 2013 16:22:39 GMT

Hi Michael,

thank you for your input! I would modify your answer a little bit to text([Part Number]) as [Part Number].