Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
miro_kopecky
New Contributor III

Load from different tables

Hello,
I have added in my script those three highlited lines and now it gives me error that filed "code" not found.
I think I need to somehow join tables Card and Codes but I dont know how to...
I would be very grateful if anybody could help me.
Thanks.

Bez názvu.png 

Labels (4)
1 Solution

Accepted Solutions
Partner
Partner

Re: Load from different tables

Something like that should fix it: (PS: i don't have these characters in excel, so go through it):

Tmp_Debit:
Load
	F1 as krajina.card,
	cislo as card,
	typ as typ.card,
From [lib://AttachedFiles/testovacie udaje.xlsx]
(ooxml, embedded labels, table is [platobnoé karty]);

Left join(Tmp_Debit)
Load
	left(numbers, 6) as card,
	numbers as code
From [lib://AttachedFiles/AU_BIN prefix.xlsx]
(ooxml, embedded labels, table is [Harok1]);

Debit:
Load
	*,
	if(......
Resident Tmp_Debit;

Drop table Tmp_Debit;
3 Replies
Employee
Employee

Re: Load from different tables

What is the relationship between the code and the other data ?

miro_kopecky
New Contributor III

Re: Load from different tables

Hi,
field 'code' is the first 6 digits of field 'card'.
But not in every case and i need to check that.
Partner
Partner

Re: Load from different tables

Something like that should fix it: (PS: i don't have these characters in excel, so go through it):

Tmp_Debit:
Load
	F1 as krajina.card,
	cislo as card,
	typ as typ.card,
From [lib://AttachedFiles/testovacie udaje.xlsx]
(ooxml, embedded labels, table is [platobnoé karty]);

Left join(Tmp_Debit)
Load
	left(numbers, 6) as card,
	numbers as code
From [lib://AttachedFiles/AU_BIN prefix.xlsx]
(ooxml, embedded labels, table is [Harok1]);

Debit:
Load
	*,
	if(......
Resident Tmp_Debit;

Drop table Tmp_Debit;