Post reply

same id,ID_SEQ,EID,TS_DT but differetn location id.

  • December 10, 2019 at 3:09 am

    #3706176

    Delete first 3 records and last two records as same day two locations should not be assigned to same id,id_seq,eid combination because it is wrong combination.

    ID | ID_SEQ| TS_DT | EID | LOCATION_ID

    123|1 | 10/10/2019 | hello | A123

    123|1 | 10/10/2019 | hello | A123

    123|1 |10/10/2019 | hello | W123

    123|1 |11/10/2019 | hello |A123

    124|1| 10/10/2019 | hello1 | S123

    124|1| 10/10/2019 | hello1 | S123

    124|2 | 10/10/2019 | hello1| A123

    456|2| 11/12/2019 | msg | A123

    456|2| 11/12/2019 | msg | S123

  • December 11, 2019 at 3:10 am

    #3706753

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply