topic Reading 2 tabels with different keylen in QlikView

Reading 2 tabels with different keylen

JACKNIEKERK — Wed, 25 Nov 2020 16:16:04 GMT

having 1 tabel with keylen 16 charters long , right ajusted like ' 123456' named eg. Productienummer;

then other tabel with keylen 8 righ ajusted like ' 123456' named eg. AflbonNumber,

Loading goes like

load
TracingKode as Productienummer;
SQL select * from TRACCODE;

load
AflbonNumber;
SQL select * from SalesTabel;

In a graph object i need to show all records from tabel SalesTabel using the key Productienummer from tabel TRACCODE

Re: Reading 2 tabels with different keylen

Taoufiq_Zarra — Thu, 19 Dec 2019 19:47:04 GMT

why not use the trim() function

Example Result

Trim( ' abc' )	Returns 'abc'
Trim( 'abc ' )	Returns 'abc'
Trim( ' abc ' )	Returns 'abc'

so the script becomes

load RowNo() as IDTACCODE, trim(TracingKode) as Productienummer; SQL select * from TRACCODE; load RowNo() as IDSalesTabel, trim(AflbonNumber) as Productienummer; SQL select * from SalesTabel;

rowno() to differentiate those from the first table from those from the second if necessary

Re: Reading 2 tabels with different keylen

jonathandienst — Fri, 20 Dec 2019 06:16:16 GMT

Try this:

TFilt:
LOAD Trim(TracingKode) as Productienummer;
SQL select TracingKode from TRACCODE;

Sales:
LOAD *
Where Exists(Productienummer, Trim(AflbonNumber);
SQL select * from SalesTabel;

DROP Table TFilt;

If the data set is large, you may want to perform a join in SQL to limit the date being transferred to Qlik.

Re: Reading 2 tabels with different keylen

JACKNIEKERK — Fri, 20 Dec 2019 08:00:48 GMT

that works

thank you