topic Re: right join and outer join not working to compare activities with customers vs whole universe of customers in Connectivity & Data Prep

right join and outer join not working to compare activities with customers vs whole universe of customers

ceuribe — Thu, 26 Sep 2024 09:16:42 GMT

Hi, I am analysing the data from our customers and I dont get to put together the analysis to compare the activies we have done with the customers vs. the universe of customers, even if I try to join the data by different joins:

I want to see if a customer has X,Y,W product in customer a,b,c... But we have a pool of N customers.

The automatic join is not working for me, unfortunately, even I tried to rename and add double values of the key ID.

I would like to see something like:

Product / Universe / # Costumers / Sucessful ratio

X / N / n / (n/N)

I tried to make an ourter join, a right join and auto connect the values, but nothing seems to work.

Re: right join and outer join not working to compare activities with customers vs whole universe of customers

Kushal_Chawda — Thu, 26 Sep 2024 10:01:43 GMT

@ceuribe Please share sample data with expected output

Re: right join and outer join not working to compare activities with customers vs whole universe of customers

ceuribe — Thu, 26 Sep 2024 10:19:51 GMT

The data is like this (left side) and I want something like this (right side).

The problem is that I should do a cross table giving each customer all the values for all the products so I can count them, is there a way to give all the customers all the values of all the products and then make a flag if something was activated, is that possible?

Re: right join and outer join not working to compare activities with customers vs whole universe of customers

Kushal_Chawda — Thu, 26 Sep 2024 10:28:08 GMT

@ceuribe may be you can concatenate your data set. Please see the below link

https://help.qlik.com/en-US/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/concatenate.htm

Re: right join and outer join not working to compare activities with customers vs whole universe of customers

ceuribe — Thu, 26 Sep 2024 12:04:09 GMT

Hi! I tried that too, it did not work, but the cross join (join with no logical connection, seems to work, the only problem is that the data load is inmense, NxM is just too big and I am not sure if there is a way to optimize it.

Re: right join and outer join not working to compare activities with customers vs whole universe of customers

Kushal_Chawda — Thu, 26 Sep 2024 12:21:36 GMT

@ceuribe If you can share sample data in excel with expected output, I will try to build optimised script