Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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.
that works
thank you