- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Synthetic key in cross table?
Hi,
Please find attached. can anyone let me know how to remove synthetic keys? in cross table.
Thanks.
- Tags:
- new_to_qlikview
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Identify which is the most important key and fields in the tables and keep those other wise remove unwanted keys or rename those keys for use on other references.
Another way is make composite key with synthetic fields by identifying those.
Eg.
Table1 Field1&Field2&Field3 as Key1
Table2 Field1&Field2&Field3 as Key1
Thanks & Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please can anyone help me.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please find attached.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Identify which is the most important key and fields in the tables and keep those other wise remove unwanted keys or rename those keys for use on other references.
Another way is make composite key with synthetic fields by identifying those.
Eg.
Table1 Field1&Field2&Field3 as Key1
Table2 Field1&Field2&Field3 as Key1
Thanks & Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
use Concatenate
or else provide the excel file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks.