Boomi Buzz: Blogs & Events
Boomi Training & Certification
About the Community
to create and rate content, and to follow, bookmark, and share content with other members.
Can we read two files and generate one output file using Boomi
Question asked by
on Feb 28, 2013
on Mar 5, 2013 by RamakrishnaKannayyagari768
Hi, I have a task to read two files and generate one output file. I need to pick up few fields from both the files and write them to one output file. Is this possible in boomi.
Thanks in advance
No one else has this question
Mark as assumed answered
This content has been marked as final.
Show 4 comments
(Required, will not be published)
Feb 28, 2013 12:44 PM
Yes. What you do is create a branch than in the first leg read the first file, load it into Document Cache in the second leg of your branch you read the second file and create a map where you can combine the file with the data you stored in Document Cache. You will need to have an index between the two files.
1 person found this helpful
Feb 28, 2013 4:35 PM
Hi, I have done the exact same way. I could see the data in the document cache. I mapped the input and output but the data is not appearing in the output file. Can you please help me with this.
Mar 2, 2013 8:16 PM
What's your index between the two files?
Mar 5, 2013 1:56 PM
I created a Cache and created an index on the ID column. In the map, I added a Document Cache Lookup for which ID was inut and address was output. I mapped input and output values and ran the process. It succeded but in the output file address value is empty.
Retrieving data ...
Does Boomi support 'Like' operator in SQL statement of the Database Profile?
How do you handle code management?
Document Tracking Best Practices
Is there any way to concatenate values from Column into a single Column ?
Create one row of data on flat file from an unbounded xml element