topic Pivot Table from 2 different tables help in QlikView

Pivot Table from 2 different tables help

Wed, 25 Nov 2020 16:16:04 GMT

Hi there, I am very new to Qlik, I have successfully created an App that displays a Pivot Table of information from 2 different tables. I just have the "Companies" associated with each other but I am running into some problems.

In both of my tables I have a column that displays Customer or Non-Customer. I have the two columns labeled differently Table 1 (Customer 1 Column) and Table 2 (Customer 2 Column). Sometimes in table 1 it will say that the company is a customer, sometimes it will say it in table 2. Sometimes both tables say it and sometimes one table says it is a customer and the other table does't.

I want to be able to show in my pivot table all customers or non-customers but it only takes information from one table or the other. I tried to create an IF function to combine the columns but it is not working correctly.

I am very new and have very little to no knowledge on scripts and code. If someone could help I would much appreciate it!

Thanks

Re: Pivot Table from 2 different tables help

Fri, 05 Aug 2016 18:17:59 GMT

Hello Shane.

Can you please add some example of data which is in both tables? How are those structured? If you can also draft what result are you expecting to get that would help

I have a feeling you just need to concatenate both tables in QV, but you did not tell if those tables carry other information as well.

BR,

Kuba

Re: Pivot Table from 2 different tables help

Fri, 05 Aug 2016 18:27:53 GMT

Thanks for the help!

Both tables have different and same data. So for instance, I want to consolidate all the emails associated with the companies. In table 1 I have some emails and in table 2 I have the same, different or no emails.

Table 1 (Email Column) | Table 2 (Email Column) | Data I want to Show

jake@qlik.com | | jake@qlik.com

| sam@qlik.com | sam@qlik.com

jerry@qlik.com | jerry@qlik.com | jerry@qlik.com

alice@qlik.com | sara@qlik.com | alice@qlik.com

I hope this shows accurately and helps!

Re: Pivot Table from 2 different tables help

Fri, 05 Aug 2016 19:02:02 GMT

Try below code:

Tab1:
LOAD * INLINE [
    CompanyID, email
    1,jake@qlik.com
    3,jerry@qlik.com
    4,alice@qlik.com
];


Join (Tab1)
Tab2:
LOAD * INLINE [
    CompanyID, email2
    2,sam@qlik.com
    3,jerry@qlik.com
    4,sara@qlik.com
];


Final:
LOAD
CompanyID,
IF(ISNULL(email) OR TRIM(email)='', email2, email) as email
RESIDENT Tab1;


DROP table Tab1;

Result:

BR,

Kuba

Re: Pivot Table from 2 different tables help

Fri, 05 Aug 2016 19:08:41 GMT

While that would be awesome and work for those specific emails, will it work for every entry in the columns? I have close to 2000 rows of emails.