Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all -
I've created QVD files from table views in our database, and now am beginning my first "real" qlikview application for testing.
When I loaded my QVDs, I got only one syn key - I'm trying to figure out why Qlikview would read these two fields (see screenshot attached) as the same. I realize that there are numbers underlying the dates in the "PA_PERIOD_NAME" column, but there doesn't seem to be any crossover.when I pull these fields into a multibox (even with DATE function or NUM functions applied)
Am I on the right track, though, that it's probably reading some overlapping id and period name numbers, and thus thinking there is a syn key situation, and I'm just missing it?
Thanks!
Those two fields are both included in more than one qvd, that's the reason for the synthetic key.
It has nothing to do with which values appear in both fields.
Maybe this helps:
regards
Marco
Those two fields are both included in more than one qvd, that's the reason for the synthetic key.
It has nothing to do with which values appear in both fields.
Maybe this helps:
regards
Marco
Thanks Marco....that was obviously the first thing I checked....I will look again in the morning with fresh eyes...
Hi,
If there are more than one common field (Field name) then Synthetic keys are generated, synthetic keys can be removed by using various techniques like
- Renaming Field names
- Creating concatenated Key fields
- Creating Linked tables
- Concatenating Tables
Check in community for sample scripts. Hope below link helps you.
Regards,
Jagan.
Wow. That's what I get for working after I'm tired. Found the cause immediately this morning! thanks for your help.
thanks! I did a rename for my problem child field.
You're welcome.
Please close your thread.
Thanks
Regards
Marco
How do I close my thread?
you already did by marking a correct answer.
thanks
regards
Marco