Repeting Values
Posted: Wed Oct 22, 2008 7:31 pm
Hi All,
I am trying to solve this problem, When ever there is a DYP in the col4 i need to replace the corresponding value in the col5 in place of COL2 like the same way COL6, COL7
same time i need to replace col3 for corresponding value for DXP.
COL1 COL2 COL3 COL4 COL5 COL6 COL7
A MMM 3
A MMM BBB
A MMM DYP XXX YYY ZZZ
A MMM DXP GGG HHH III
A MMM
A MMM
A MMM
COL1 COL2 COL3 COL4 COL5 COL6 COL7
A XXX 3
A XXX GGG
A XXX DYP XXX YYY ZZZ
A XXX DXP GGG HHH III
A XXX
A XXX
A XXX
COL1 COL2 COL3 COL4 COL5 COL6 COL7
A YYY 3
A YYY HHH
A YYY DYP XXX YYY ZZZ
A YYY DXP GGG HHH III
A YYY
A YYY
A YYY
COL1 COL2 COL3 COL4 COL5 COL6 COL7
A ZZZ 3
A ZZZ III
A ZZZ DYP XXX YYY ZZZ
A ZZZ DXP GGG HHH III
A ZZZ
A ZZZ
A ZZZ
I tried to pivot col5,col6 col7 if they are DYP then try to lookup with the same data. Please give me some suggestions.
Thanks for your sugestions.
I am trying to solve this problem, When ever there is a DYP in the col4 i need to replace the corresponding value in the col5 in place of COL2 like the same way COL6, COL7
same time i need to replace col3 for corresponding value for DXP.
COL1 COL2 COL3 COL4 COL5 COL6 COL7
A MMM 3
A MMM BBB
A MMM DYP XXX YYY ZZZ
A MMM DXP GGG HHH III
A MMM
A MMM
A MMM
COL1 COL2 COL3 COL4 COL5 COL6 COL7
A XXX 3
A XXX GGG
A XXX DYP XXX YYY ZZZ
A XXX DXP GGG HHH III
A XXX
A XXX
A XXX
COL1 COL2 COL3 COL4 COL5 COL6 COL7
A YYY 3
A YYY HHH
A YYY DYP XXX YYY ZZZ
A YYY DXP GGG HHH III
A YYY
A YYY
A YYY
COL1 COL2 COL3 COL4 COL5 COL6 COL7
A ZZZ 3
A ZZZ III
A ZZZ DYP XXX YYY ZZZ
A ZZZ DXP GGG HHH III
A ZZZ
A ZZZ
A ZZZ
I tried to pivot col5,col6 col7 if they are DYP then try to lookup with the same data. Please give me some suggestions.
Thanks for your sugestions.