I need to filter a column the name of the is “D” the conditions are:
- Filter the “D” column with “C”(Credit) keep “C” related data , and delete the “D”(Debit) related data.
- Filter the “D” column with “D”(Debit) keep “Debit” related data , and delete the “C”(Credit) related data.
- At the end need to select both. I meant I am trying to separating the credit and debit column(FCY_AMOUNT) in debit column there should be only debit related data and credit column(LCY_AMOUNT) should contains credit related data.
Please Do needful.
Naveen Kumar S
Screenshot 45-Output after filtering as said.
Screenshot 46-Input file