Salam kenal, mencoba ikut membantu, mohon koreksinya jika salah, tabel:
SOURCE DESTINA NILAI A B 1,000 A C 100 B A 1,000 B C 0 C A 100 C B 0 untuk tabel matrix/pivot biasanya saya gunakan "decode" untuk mengambil nilai matrixnya sesuai tabel diatas, skripnya sbb: select source as descripion, sum(decode(DESTINA,'A',nilai,0)) "A", sum(decode(DESTINA,'B',nilai,0)) "B", sum(decode(DESTINA,'C',nilai,0)) "C" from com group by source dan hasilnya : DESCRIPTION A B C A 0 1,000 100 B 1,000 0 0 C 100 0 0 Mohon dikoreksi jika salah, Salam Kenal, Cakmamed --- On Mon, 4/13/09, Izzudin Hanafie <[email protected]> wrote: From: Izzudin Hanafie <[email protected]> Subject: Fw: [indo-oracle] help : query matrix To: [email protected] Date: Monday, April 13, 2009, 2:12 AM Wah...kok tampilannya malah jadi aneh yaa..padahal sudah dibuat table2nya. Berikut saya rapihkan kembali sumber data dan hasil yang diinginkan : Sumber data : ------------ --------- --------- --------- --------- --------- - Company Asal Company Tujuan Nilai ------------ --------- --------- --------- --------- --------- - Company A Company B 1000 Company A Company C 100 Company B Company A 1000 Company B Company C 0 Company C Company A 100 Company C Company B 0 ------------ --------- --------- --------- --------- --------- - Hasil yang diinginkan : ------------ --------- --------- --------- --------- --------- - Description Company A Company B Company C ------------ --------- --------- --------- --------- --------- - Company A 0 1000 100 Company B 1000 0 0 Company C 100 0 0 ------------ --------- --------- --------- --------- --------- - Regards IH [Non-text portions of this message have been removed]
