In my source table data is
s_name,p_name,value
s1 , p1, 10
s1 , p2, xyz
s1 , p3 , abc
s2 , p1 , 20
s2 , p2 , xyz
s2 , p3 , abc
I want two target tables, first table is based on s_name s1, second table based on s_name s2. Both table contains contains p_name and value.
The target table data like as
Table s1
p_name,value
p1, 10
p2, xyz
p3, abc
Table s2
p_name,value
p1, 20
p2, xyz
p3, abc