Is there any function which creates Synthetic key in Qlikview?
Yes/No. Please comment if there is any function
Synthetic key is due to more than one common key between tables in Script. We don't have synthetic keys until there are no two common keys between tables.
But when we use interval match function, It will create synthetic key as this is the nature of this function. Using proper join, we can remove this
Yes/No. Please comment if there is any function
Synthetic key is due to more than one common key between tables in Script. We don't have synthetic keys until there are no two common keys between tables.
But when we use interval match function, It will create synthetic key as this is the nature of this function. Using proper join, we can remove this
No
ReplyDeleteThis comment has been removed by the author.
DeleteInterval match creates but can be removed
Deleteno
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteYes, interval match.
ReplyDeleteIt creates but you have options or way to remove those
DeleteYes
ReplyDeleteYes..
ReplyDeleteYes. interval match creates synthetic key and can be removed by join as explained above
ReplyDeleteThanks for all your comments
ReplyDelete