SPLIT SOURCE DATA INTO TWO FILES

Source file is having item details. Item names are ending with the letter E or K. I want to split the data based on the product name ending letters (E and K) and create two different files.

Source file data:

Id,Name,Price
101,tee,10
102,cofee,20
103,milk,15
104,cool drink,20
105,hot drink,19
106,Chocolate,9

Expected output files:

    Target 1:
Id,Name,Price
103,milk,15
104,cool drink,20
105.hot drink,19

    Target 2:
Id,Name,Price
101,tee,10
102,cofee,20
106,Chocolate,9

Package creation: Click here