We have file having country_name customer_name.For exp London Ram Bangalore Ro

We have file having country_name customer_name.For exp
London Ram
Bangalore Rohit
London Shyam
Bangalore Abhinav
In output we need 2 files one file for london and second file for Bangalore.How to acheve this?

Question Posted / ritika

4 Answers
8974 Views
IMS, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam B..

Answer / subramanian

Set Count Parameter in Reformat to 2 to create 2 output ports.
Use Output_index parameter in Reformat Component to direct the record with city field having 'London' to one of the port .

Another condition checking city field for 'value 'Bangalore' and direct it to second out port.

count parameter set to 2.

if (field_1 == "London") 0
else
1

Is This Answer Correct ?

20 Yes

2 No

We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam B..

Answer / keerthika

We can use Partition By expression to partition the data based on the Value in input data

Is This Answer Correct ?

7 Yes

0 No

We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam B..

Answer / devendra majhi

We can use "Write Multiple Files" component for this.
assign filename field with whatever expression you like and create file dynamically.
But select "oerwritte" option as false in that component

Is This Answer Correct ?

4 Yes

1 No

We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam B..

Answer / ritika

Thanks Subramaniam....but I want the result as generic. In this you are assuming only two cities that is London and Bangalore but it can be any number of cities, today it is coming only london and Bangalore later it can come as Delhi, Chennai and Bangalore. In this way we have to create separate output file for each city.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer