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