Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Join two tables with a third one, BUT NOT BETWEEN THEM on that field(!!)

Hello,
i understand that my questions sounds weird so let me explain.

For example, we have a table Payments that includes Date and this Date becomes linked with the Date of my master calendar. Additionally, we have a table invoices that includes Date, but if I keep the same name I get a synthetic table instead because Payments and Invoices are already linked on a supplier ID (!!). So, is there a way to connect Payments Date to Date and invoice Date to Date but NOT Payment Date to Invoice Date on the date field (I still need them to be connected through supplier ID)?? This is only one example, I have many in my script.

Thanks,
Joseph

Tags (2)
7 Replies
Not applicable

Re: Join two tables with a third one, BUT NOT BETWEEN THEM(!!)

Hi,

Try:

In ur master calender:

Calender Date as [Payment Date] ,

Calender Date as [Invoice Date]

Regards

Not applicable

Re: Join two tables with a third one, BUT NOT BETWEEN THEM(!!)

Hi. Thanks for your reponse. I tried that but it doesn't accept the code.

I also updated the description to reflect better what my problem is, take a look.

Thanks

Re: Join two tables with a third one, BUT NOT BETWEEN THEM on that field(!!)

If your two tables are joined on supplier_id then you can't join a master calendar table on both tables. You'll have to use two calendar tables (recommended) or a data island calendar table and use variables and triggers to select a date in both tables.


talk is cheap, supply exceeds demand
Not applicable

Re: Join two tables with a third one, BUT NOT BETWEEN THEM on that field(!!)

Thanks Gysbert

I will have to try that tomorrow at work. Nonetheless, I have the same problem witha table countries that has the names and coordinates of all countries. This is currently linked to to the payment country and it works fine. When I am trying to load it again as another table from the same excel source (or even a copy of that file) in order to idependently link it with the supplier home_country (different name as well) I get an error that the first field of the excel column was not found! This is bizarre because it loads fine when creating the first countries table (that links to payments) but it doesnt when I want to create the same table as Countries2 in order to link it to supplier home_countries.

Is the situation clear?

Re: Join two tables with a third one, BUT NOT BETWEEN THEM on that field(!!)

If I understand it correctly you have something like this to load the countries from excel:

countries:

load a, b, c

from countries.xls (biff, embedded labels, table is Sheet1$);

and then you try to do a second load with a different field name for the first field:

countries2:

load a1, b, c

from countries.xls (biff, embedded labels, table is Sheet1$);

If you do that I understand why it doens't work. The excel file is still the same, with the same field names. You want to rename the first field so you have to use 'as':

countries2:

load a as a1, b, c

from countries.xls (biff, embedded labels, table is Sheet1$);


talk is cheap, supply exceeds demand
Not applicable

Re: Join two tables with a third one, BUT NOT BETWEEN THEM on that field(!!)

I'll try that but imagine that it doesn't work even if I load countries2 from a DIFFERENT excel file (copy of the previous one but with another name and different column names...). Does this make sense?

Not applicable

Re: Join two tables with a third one, BUT NOT BETWEEN THEM on that field(!!)

Hi,


I solved. I was using the wrong sheet name.

Thanks all

Community Browser