PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 01/22/2016 9:38 AM by  thummel1
Duplicate Row Info Set
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
thummel1
Data Analyst II
Fairview Health Services
Veteran Member
(183 points)
Veteran Member
Posts:101


Send Message:

--
01/21/2016 11:45 AM
    Greetings,

    I have an Info Set that is designed to deliver a Smart Notification to managers when employees are due for various required exams. It has Employee ID, Exam Type, Due Date and manager email. There is one employee that has 2 unique Exam Types due on the same day for the same manager. When I update the info set, the Info Set ignores attempt to create a duplicate record, which is excluding one of the Exam Types for this one employee, but this is clearly not a duplicate record becasue each record has a unique Exam Type.

    I've tried grouping and sorting my SQL on all items in the select statement, putting the Exam Type first in the Group By and Sort By, and removed all grouping and sorting altogether and the Info Set still removes this one record.

    What's the trick to get this additional record to appear in my Info Set??:blink:

    Thanks!
    The.Sam.Groves
    Programmer Analyst
    St Lukes Hospital
    Veteran Member
    (265 points)
    Veteran Member
    Posts:89


    Send Message:

    --
    01/22/2016 8:17 AM
    You likely have it set to filter on unique key, if so and if that's intended then make sure that your infoset has all the key fields marked as keys. That includes the Exam Type.

    Or alternatively switch the filter to "unique row" or "no filter".

    This is all controlled on the screen where you define the fields being pulled in. The filter should be at the top of the screen and you designate a field as a key or an attribute in the left most box for field definitions. At least in my version.
    thummel1
    Data Analyst II
    Fairview Health Services
    Veteran Member
    (183 points)
    Veteran Member
    Posts:101


    Send Message:

    --
    01/22/2016 9:38 AM
    Yes I realized yesterday afternoon that I needed to add an additional key, the Exam Type. I only have one key set, which was on Employee ID. I changed that and it fixed the issue. THank you!
    thummel1
    Data Analyst II
    Fairview Health Services
    Veteran Member
    (183 points)
    Veteran Member
    Posts:101


    Send Message:

    --
    01/22/2016 9:38 AM
    Yes I realized yesterday afternoon that I needed to add an additional key, the Exam Type. I only have one key set, which was on Employee ID. I changed that and it fixed the issue. THank you!
    You are not authorized to post a reply.