Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i've been searching the community for a couple of days, seems like i cant figure out how to solve this one.
i have 7 tables
Main table
DataDetails:
LOAD Id,
[Delivery Postal Code],
[Forwarder Track],
left join
LOAD [Delivery Postal Code],
Zone
To define the weight clas
GewichtKlassen:
LOAD Min,
Max,
Gewicht_Klasse
inner join IntervalMatch (LAN_Weight)
load Min,
Max
Resident
GewichtKlassen;
Rates based in Zone and weight
Landmark_Prices:
LOAD Price_ID,
Price as LA_Price
now I would like to make a key in the table Data details something like
trim (Zone&'-'&Gewicht_Klasse) as Price_ID
then i would be able to link the table DataDetails with Landmark_Prices
but when doing this i get an error that "Gewicht_Klasse" cannot be found (probably because its in another table?)
Jens,
thank you for the responce.
i've tried to join "Gewicht_Klasse" into Landmark_Invoices.
but could not do this (probably just because i dont know how...)
because "Gewicht_Klasse" comes from an inner join intervalMatch from Gewichtklassen
do you know how to left join this into Landmark_Invoices?
Landmark_Invoices:
LOAD [Customer Ref],
[Processed/Returned Date] as LAN_Invoice_Date,
[Weight (lb)] as LAN_Weight,
[Base Charge],
[Additional Charges],
[Total Charge]
FROM
GewichtKlassen:
LOAD Min,
Max,
Gewicht_Klasse
FROM
// i've tried (Red) but failed...
left join
inner join IntervalMatch (LAN_Weight)
load Min,
Max
Resident
GewichtKlassen;
hey, brilliant !
this works perfecty.
i just needed to add 1 row under the last join:
drop field Gewicht_Klasse from GewichtKlassen;
Else i would have created a circle, but with this line included it works perfrctly.