Avoiding Synthetic Keys in Multiple Data Connections

[hammermill21]

Hello!

I have 5 excel sheets I am using for an app and each sheet has the following columns:

Year

Month

Quarter

PScore

HScore

Obviously, they cause a synthetic key because they are duplicated for the most part. I can't change the format of the excel sheet but is there something I can do in Qlik to avoid this? Would renaming them be the key to avoiding it?

Thank you1

Updated file

[passionate]

Why don't you use a link table

[hammermill21]

I have obviously added the Source file incorrectly because it still happening. I have attached my new updated file to the original message.

Thank you for your help, I really appreciate it.

[Anonymous]

What viz has the incorrect figure in it and what is the figure and what should it be ?

Also what is the expression ?  I don't have the VizplumTextObject extension so cannot see what is happening in those 4 viz's, which is probably why I am confused.

[hammermill21]

The Total Compliant Humidity count which is a KPI object is what is incorrect. The expression is: =Count({<HScore= {'1'}>} HScore), which should be 1277 and it's counting 2108. If I go check room by room I find that it is doubling the first count of rooms, which is coming from the main tab in the backend. The one you recommend I should leave the script as is (2018 Humidity March as is, as that will be creating the Final table to later be concatenated onto.). So I'm wondering if I should have added something to the script also?

[Anonymous]

Your first 3 script tabs are :

• Main
• Section
  • LIB CONNECT TO 'Smartsheet DSN - 2018 March OR Humidity Monitor (uhealth_54171224)';
  • Loads ...  FROM "2018 OR Humidity Monitor March__1357343347763076s_(Home)"
• 2018 Humidity March
  • LIB CONNECT TO 'Smartsheet DSN - 2018 March OR Humidity Monitor (uhealth_54171224)';
  • Loads ...  FROM "2018 OR Humidity Monitor March__1357343347763076s_(Home)"

And from a quick eyeball tabs Section & 2018 Humidity March look the same, so you could well be loading some data twice.

Is that what you intend ?

[hammermill21]

OH MAN!!! I was loading it twice!!! What a foolish mistake, I think I was testing and must have duplicated it.

I'm sorry to have wasted your time with that!

Thank you again.

[Anonymous]

No worries, it is easy to go snowblind after staring at a script all day and then not see the blindingly obvious - I do it more often than I care to admit.