Hi all,
I have in my DB the fallowing :
Master & derivatives
COULMN
XXX-XXX-NUM-16-009 (MASTER) between the brackets for explination,its not included in the data
XXX-XXX-NUM-16-009 (MASTER) between the brackets for explination,its not included in the data
XXX-XXX-NUM-16-009C1 (derivatives) between the brackets for explination,its not included in the data
XXX-XXX-NUM-16-009C2 (derivatives) between the brackets for explination,its not included in the data
XXX-XXX-NUM-16-009C3 (derivatives) between the brackets for explination,its not included in the data
XXX-XXX-NUM-16-010
XXX-XXX-NUM-16-010
XXX-XXX-NUM-16-010C1
XXX-XXX-NUM-16-010C2
XXX-XXX-NUM-16-010C3
XXX-XXX-NUM-13-007C1
XXX-XXX-NUM-13-007C2
XXX-XXX-NUM-13-007C3
I have around 14000 row every master have derivatives (sometimes 1 derivative or 2 or 3 or more) and rarely without any derivative.
But its a must, if there is a derivative there should be Master.
My concern is to search and find if there is any derivative without master, to highlight the data with any C's which doesn't have the master
For example:
to highlight the fallowing or to extract the fallowing from the above example (the answer will be)
XXX-XXX-NUM-13-007C1
XXX-XXX-NUM-13-007C2
XXX-XXX-NUM-13-007C3
Thanks
I have in my DB the fallowing :
Master & derivatives
COULMN
XXX-XXX-NUM-16-009 (MASTER) between the brackets for explination,its not included in the data
XXX-XXX-NUM-16-009 (MASTER) between the brackets for explination,its not included in the data
XXX-XXX-NUM-16-009C1 (derivatives) between the brackets for explination,its not included in the data
XXX-XXX-NUM-16-009C2 (derivatives) between the brackets for explination,its not included in the data
XXX-XXX-NUM-16-009C3 (derivatives) between the brackets for explination,its not included in the data
XXX-XXX-NUM-16-010
XXX-XXX-NUM-16-010
XXX-XXX-NUM-16-010C1
XXX-XXX-NUM-16-010C2
XXX-XXX-NUM-16-010C3
XXX-XXX-NUM-13-007C1
XXX-XXX-NUM-13-007C2
XXX-XXX-NUM-13-007C3
I have around 14000 row every master have derivatives (sometimes 1 derivative or 2 or 3 or more) and rarely without any derivative.
But its a must, if there is a derivative there should be Master.
My concern is to search and find if there is any derivative without master, to highlight the data with any C's which doesn't have the master
For example:
to highlight the fallowing or to extract the fallowing from the above example (the answer will be)
XXX-XXX-NUM-13-007C1
XXX-XXX-NUM-13-007C2
XXX-XXX-NUM-13-007C3
Thanks