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

What does it mean by the term 'sort component'?

843


What is a deadlock and how it occurs?

847


Describe the grant/revoke ddl facility and how it is implemented?

884


What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.

698


What is a look-up?

839






You can ask about different vector functions. How to use in abinitio graph?

5235


What is rollup component?

876


What is air-project parameter ?

1929


What is the difference between dml expression and xfr expression?

828


What is a cursor? Within a cursor, how would you update fields on the row just fetched?

899


What is the importance of eme in abinitio?

859


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

2036


List out the file extensions used in abinitio?

813


Can you explain the co>operating system’s processing model?

819


Can anyone give me an example of realtime start script in the graph?

890