i hope my data will only be a few hundred column and thousands row, instead of few column and millions row. as you might see, this is financial statement from thousands counterparty. i want each counterparty become rows, and financial account become column.   might you can help? ... View more

Its still didn't works. there's no error messages, but the result s are not as expected COUNTERPARTY_RK _LABEL_ k_1 k_2 k_3 k_4 k_..3035265 15808376 VALUE_NUMBER 0 1013 0 84409 0 15808379 VALUE_NUMBER . . . . . 15808381 VALUE_NUMBER . . . . . ... View more

as you might guess. my data have several thousands unique counterparty_rk and several hundreds technical_key that repeating/looping for every counterparty_rk. i haven't try kurt's solution. but, when i have try it. i will let you know about the log and error messages   Thanks for your help @Kurt_Bremser . i'm very appreciated it, i will inform you about the log and error messages immadiately ... View more

same errors as before.   ERROR: The ID value "FS_BS_CURR_ASSETS_TRD_RECV_N_REL" occurs twice in the same BY group.   do you have any suggestion? ... View more

I think you're right. it's "edge cases", for my examples its work perfectly. but for my data, it can't.   so this is my real data: COUNTERPARTY_RK TECHNICAL_KEY VALUE_NUMBER 15808376 FS_BS_CURR_LIA_LFA_SUBS_N_TRD 0 15808376 FS_BS_CURR_LIA_LFA_RELATED_AFFILIATED_N_TRD 1013 15808376 FS_BS_CURR_LIA_LFD_SHAREHOLDER_N_TRD 0 15808376 FS_BS_CURR_LIA_TOL_OTH_CURR_LIA 84409 15808376 FS_BS_CURR_LIA_OUTSTNDG_CONTRACTS_PAYABLE 0 etc up to million row ... ...   i want the following : COUNTERPARTY_RK FS_BS_CURR_LIA_LFA_SUBS_N_TRD FS_BS_CURR_LIA_LFA_RELATED_AFFILIATED_N_TRD FS_BS_CURR_LIA_LFD_SHAREHOLDER_N_TRD FS_BS_CURR_LIA_TOL_OTH_CURR_LIA FS_BS_CURR_LIA_OUTSTNDG_CONTRACTS_PAYABLE 15808376 0 1013 0 84409 0   can you help me? ... View more

I think you're right. it's "edge cases", for my examples its work perfectly. but for my data, it can't.   so this is my real data: COUNTERPARTY_RK TECHNICAL_KEY VALUE_NUMBER 15808376 FS_BS_CURR_LIA_LFA_SUBS_N_TRD 0 15808376 FS_BS_CURR_LIA_LFA_RELATED_AFFILIATED_N_TRD 1013 15808376 FS_BS_CURR_LIA_LFD_SHAREHOLDER_N_TRD 0 15808376 FS_BS_CURR_LIA_TOL_OTH_CURR_LIA 84409 15808376 FS_BS_CURR_LIA_OUTSTNDG_CONTRACTS_PAYABLE 0 etc up to million row ... ...   i want the following : COUNTERPARTY_RK FS_BS_CURR_LIA_LFA_SUBS_N_TRD FS_BS_CURR_LIA_LFA_RELATED_AFFILIATED_N_TRD FS_BS_CURR_LIA_LFD_SHAREHOLDER_N_TRD FS_BS_CURR_LIA_TOL_OTH_CURR_LIA FS_BS_CURR_LIA_OUTSTNDG_CONTRACTS_PAYABLE 15808376 0 1013 0 84409 0   can you help me? ... View more

Thanks for reply. but the code did't work. log: ERROR: The ID value "1" occurs twice in the same BY group. ERROR: The ID value "2" occurs twice in the same BY group. ERROR: The ID value "3" occurs twice in the same BY group. ... View more