I'm trying to import data file which is in csv format in that i have four column "Account", "Entity", "Cost Center", "Debit total bal." and "Credit total bal". In debit and credit column if debit is "o" there there is value for credit and vice versa both are not zero at same time . when i import it i got only values from debit column and that is also only non zero (avoid zero values for debit too ) . I cant understand why its avoiding credit values ?
In CSV file format how we can use DRCRSplit ? Is it possible through Import(DataPump) Script ?
Expected Result is = In amount column there should be value which is non zero either it is debit or credit.