topic Re: Issue with Join in App Development

Issue with Join

jpjust — Tue, 01 Mar 2022 16:06:49 GMT

All,

I tried so hard but couldnt figure this out. Any help will be appreciated.

I have 2 queries like below.

[AppName]:

LOAD
ObjectId as ObjectID,
"App Name" as AppName,
AppId as AppID,
_AppKeyNA
FROM [lib://QVD_FOLDER/Licenses/AppNameNA.QVD]
(qvd);

[SessionNA]:
load
ObjectId as ObjectID
"Session Count"

FROM [lib://QVD_FOLDER//Sessions.QVD]
(qvd) ;

The above query gives me the correct number of records as below for an table. The datamodel will be 2 tables with join between ObjectID

AppName AppID Session Count

ABC 123 66,559

If I do an inner join (Because I want as a single table in datamodel), the session count just doubles (113,118)

I tried left join and the session count doubles as well.

Is there a way to keep as single table in datamodel while have the correct session count?

Thanks

Re: Issue with Join

anthonyj — Wed, 02 Mar 2022 05:34:20 GMT

Hi @jpjust ,

It sounds like the "ObjectID" in your AppName has duplicates causing the [Session Count] to duplicate. Can you check the Data Model viewer under Preview and click on "ObjectID" in the "AppName" table. See if it says "Duplicates: True"

Thanks

Anthony

Re: Issue with Join

jpjust — Wed, 02 Mar 2022 17:04:13 GMT

Thanks Anthony. There are duplicates in AppName table, so I had to use distinct on AppName table and then

sum(session count) with group by object ID on session table to fix the data duplication issue. Is there any other alternative approach to this?

However, I don't see the preview with "Has Duplicates" view. I am using qliksense enterprise.

Thanks