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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention what the difference between “look-up” file and “look is up” in abinitio?

792


what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?

3361


What is the importance of eme in abinitio?

665


Explain PDL with an example?

800


What a local lookup is?

601






What do you mean by a transaction file?

667


How you can run a graph infinitely in ab initio?

774


Can you explain data flow graph with an example?

703


Is data warehousing different from data mining?

629


Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com

1815


What is the max core of a component?

616


How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

1477


Explain the methods to improve performance of a graph?

668


What is the difference between check point and phase?

678


What is the difference between sandbox and EME?

675