topic Re: Join table to two other tables in QlikView

Join table to two other tables

QlikLearner21 — Wed, 25 Nov 2020 16:16:04 GMT

Hi.

I am re-starting my Qlikview knowledge so not a complete beginner but a beginner none-the-less!

I have a question re a load script.

I have a 'Main' data table (in Excel for now but will be a SQL connection when fully working) and 2 separate Excel 'look-up' tables. The join to the first table is straight forward however the second join requires linking to one variable in the Main data and another in the first look-up.

For example. The Main table has a "Company" field and a "Product" field. In the first lookup, I am 'cleaning' the company name, so "Ford Motor Co" returns "Ford" and so on.

The second look-up needs to join on the "Company_Cleaned" field (i.e. the "Ford" rather than "Ford Motor Co" and on the Product in Main.

I have searched many answers but I cannot seem to find out how to do it. I suspect I am missing something very basic!

Thanks in advance

Re: Join table to two other tables

rubenmarin — Fri, 16 Oct 2020 07:07:33 GMT

Hi, If you have Main table with "Company" and "Product" field, you do a join (left or inner) with the first excel, that has a "Camponay" and a "Company_Cleaned" field this add the "Company_Cleaned" field to the Main table, then the last excel has a "Company_Cleaned" and a "Product" field. If you do a join with the main table it should add all the fields from this table to the main table.

Possible issues can be:

- Fields have not the same name

- Values are slightly different (uppercases, spaces, symbols...).

- First excel add another field with the same name as inthe 2nd excel, so it also looks for the same values to do the join.

You haven't said what kind of issue you found, a sample data or document to demonstrate the issue can be helpful to find the solution.

Re: Join table to two other tables

QlikLearner21 — Fri, 16 Oct 2020 13:47:16 GMT

Hi. Yes a left join to the main table worked.

Thanks for your help!