Hi Friends,
I need to pivot data .
Below is my source data
Source Data
PK PRTY_KEY_ID PRTY_SUB_KEY_ID KEY_COL_VAL_TX MTCH_CNFDNCE_RATE
007824822 428844791 1 #Jemmy#Pom#600 Kearsarge Way 100
007824822 429283974 1 #Jemmy#Pom#120 Broadway 100
007824822 429739103 1 #Jemmy#Pom#600 Keae Way#757 90
007824822 429834732 1 #Jemmy#Pom###10128 80
007824822 429840574 1 #Jemmy#Pom###10271 80
007824822 429845694 1 #Jemmy#Pombriant###03801 80
369540998 428511642 1 #C Ann#Gracer#7320 Mundy Ln 100
369540998 429296516 1 #C Ann#Gracer#2150 Linda Dr 100
369540998 429855219 1 #C#Gracer###48356 80
===================================
I need output like below
PK PRTY_KEY_ID SUB_KEY MTCH_PRTY_KEY_ID KEY_COL_VAL_TX
007824822 428844791 1 429739103 #Jemmy#Pom#600 Keae Way#757
007824822 428844791 1 429834732 #Jemmy#Pom###10128
007824822 428844791 1 429840574 #Jemmy#Pom###10271
007824822 428844791 1 429845694 #Jemmy#Pombriant###03801
007824822 429840574 1 429739103 #Jemmy#Pom#600 Keae Way#757
007824822 429840574 1 429834732 #Jemmy#Pom###10128
007824822 429840574 1 429840574 #Jemmy#Pom###10271
007824822 429840574 1 429845694 #Jemmy#Pombriant###03801
369540998 428511642 1 429855219 #C#Gracer###48356
369540998 429296516 1 429855219 #C#Gracer###48356
===================
For each 100 percent PRTY_KEY_ID for same PK, I need to list down its all 90 and 80's PRTY_KEY_ID
So for PK = 007824822, FOR first 100 % PRTY_KEY_ID (428844791), I will need four rows(3 FOR 80 and 1 for 90)
for PK =007824822, , For next 100% PRTY_KEY_ID (429840574),I will need four rows(3 FOR 80 and 1 for 90)
Thne next PK and so on
===============
Need your help
Thanks in advance.