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
Mention what the difference between “look-up” file and “look is up” in abinitio?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
What is the importance of eme in abinitio?
Explain PDL with an example?
What a local lookup is?
What do you mean by a transaction file?
How you can run a graph infinitely in ab initio?
Can you explain data flow graph with an example?
Is data warehousing different from data mining?
Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com
What is the max core of a component?
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
Explain the methods to improve performance of a graph?
What is the difference between check point and phase?
What is the difference between sandbox and EME?