How to get unique values from a column using OIC

We are trying to read a file and convert it into a FBDI file so that it's loaded into Oracle Fusion. Our Initial file will look like below

Name	City	Country	Phone
Suki	Manchester	UK	10001
Sam	Liverpool	UK	10002
Tina	London	UK	10003
Bob	Manchester	UK	10004
Alice	New York	USA	20001
Charles	Los Angeles	USA	20002
Maya	New York	USA	20003
Ravi	Mumbai	India	30001
Priya	Bangalore	India	30002
Nadia	Sydney	Australia	40001

We then have to produce 4 files

File 1
Fixed structure - no help needed

File 2 (List of countries)

UK
USA
India
Australia

File 3 (List of city-country pairs)
Mancheter-UK
London-UK
Liverpool-UK
New York-USA
Los Angeles-USA
….

File 4 (List of City-Country-Phone pairs)