Load from different tables

[miro_kopecky]

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.

 

[Lisa_P]

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

[miro_kopecky]

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

[Kalmer · Accepted solution]

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;