Hi experts,
Could you please advise me about SPL?
Given the data below, I would like to rewrite the id with a type value of 2 to the id value with a type value of 1 for data with the same axid value.
---------------------- axid, id, type ---------------------- 0001,abc,1 0001,def,2 0001,ghi,2 0002,jkl,1 0002,mno,2 0002,pqr,2
Expected results follow
---------------------- axid, id, type ---------------------- 0001,abc,1 0001,abc,2 0001,abc,2 0002,jkl,1 0002,jkl,2 0002,jkl,2
Thanks in adance!!
... View more