callsresri
Contributor III
2014-09-11
11:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
incremental load with out primary key
Hi Experts,
Need help on incremental load:
is there any to extract update records from DB table to QlikView with out primary key?
Thanks,
Sree
980 Views
4 Replies
MK_QSL
MVP
2014-09-11
11:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Primary key is essential for incremental Load if the case is Insert or update or delete...!
590 Views
callsresri
Contributor III
2014-09-11
12:10 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Manish,
Thank you for your reply.
In this case, can't we create a dummy key to handle the load?
Regards,
Sree
590 Views
ashfaq_haseeb
Champion III
2014-09-11
01:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You need yo have primary key and date.
If you don't have primary key then it would be a bit difficult.
Regards
ASHFAQ
590 Views
MK_QSL
MVP
2014-09-11
02:40 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Answer can be given only after checking your fieldnames / tables...
590 Views