Is it possible?

[#1]

Dear all

A want to lnow if it's possible to do a left join with where clause, because all the time it says field doen't exist.

LEFT Join(A) Load * resident B Where A.Field = B.Field;

Best regards

[#2]

In Qlikview, you don't reference fields using table aliases. You also can't tell Qlikview what to join on. It's going to join the tables based on common fields. (ie: feilds of exactly the same name)

What you need to do is rename the fields in both tables, so they are the same, before you join them together.

[#3]

I think my question is not correctly expossed.

I want to do a left join with a between

Table 1 Fields: Country, Postal Codes, Shipment

Table 2 Fields: Country; Postal Code From; Postal Code To; Time

I want to do a left join Where Postal codes Betwwen From and To

Thanks and best regards,

[brenner_martina]

Hi Jordi,

for that you have to use the function intervalmatch!

[#5]

Only one more question.

If I want to do multiple intervalmatch, how can i do that

Example

Table 1: Country, Postal Code, Arrival Hour

Table 2: Country, From Postal Code, To Postal Code, From Hour, From Hour, To Hour, Transit

Best regards.

[brenner_martina]

Hi,

I do not understand your question, but you can enter the function intervalmatch more than once! you can also enter a loop by for counter=1 to X and next

[#7]

I want to know if it's possible to do an interval match for two different fields in only one sentence

Example

Table 1: Country, Postal Code, Arrival Hour

Table 2: Country, From Postal Code, To Postal Code, From Hour, From Hour, To Hour, Transit

Join table1 intervalmatch(Postal Code, Arrival Hour) Load From Postal Code, To Postal Code, From Hour, To hour Resident Table 2.

I want to do in only one senten 2 intervalmatch

First One: Postal Code between From Postal Code and To Postal Code

Second One: Arrival Hour betwwen From Hour, To Hour

Best regards,

[brenner_martina]

Hi, Jordi,

no, you have to do that in two statements