Hi all,
I have security id and owner id as the table below and would like to group the owner
with different security id and generate new owner_group_id as result below:
any input would be highly appreciated
Thank you
I have security id and owner id as the table below and would like to group the owner
with different security id and generate new owner_group_id as result below:
Code:
data
secu_ID Owner_ID
000000000007016 000CARLE0C4S000
000000000007016 000CRAICARHO001
000000000007016 000NATAHOLDI000
000000000007016 000CARLCOPTL000
000000000007016 000CARLE0M4S000
000000000696197 000MCVIFAMTR002
000000000696197 000MCVITRPTL000
000000000696197 000MERMBETPL000
000000000696197 000ROSSFIHPL000
000000000696197 000ROSSHOTTR000
000000000696198 000MCVIFAMTR002
000000000696198 000MCVITRPTL000
000000000696198 000MERMBETPL000
000000000696198 000ROSSFIHPL000
000000000696198 000ROSSHOTTR000
Code:
expected result:
SECU_ID Owner_group_Id
000000000007016 1
000000000696197 2
000000000696198 2
any input would be highly appreciated
Thank you