AnsweredAssumed Answered

Merge two flat files - document cache

Question asked by RohithKodakandla5291 on Mar 17, 2016
Latest reply on Mar 18, 2016 by RohithKodakandla5291


I'm trying to use the process described here https://community.boomi.com/message/3212#comment-3212 to merge two flat files. I've One-to-One relationship in my use case. It should be a straightforward mapping. But I think I'm making a mistake in the document cache as the output profile doesn't look the way I want.

 

Input files

 

skills.txt

Employee ID*Skill1*Skill2

12345*Core Java*Boomi

23352*MS Word*MS Excel

 

employees.txt

Employee ID*First Name*Last Name*Middle Name*Title

12345*John*Doe*Jake*Java Developer

23352*Jane*Doe*Lily*Business Analyst

 

What I want in the ouput

Employee ID*First Name*Last Name*Middle Name*Title*Skill1*Skill2

12345*John*Doe*Jake*Java Developer*Core Java*Boomi

23352*Jane*Doe*Lily*Business Analyst*MS Word*MS Excel

 

What I'm getting

Employee ID*First Name*Last Name*Middle Name*Title*Skill1*Skill2

12345*John*Doe*Jake*Java Developer*Core Java*Boomi

23352*Jane*Doe*Lily*Business Analyst*Core Java*Boomi

 

Process

 

Screen Shot 2016-03-17 at 10.39.14 PM.png

 

Document Cache setup

 

Screen Shot 2016-03-17 at 10.39.28 PM.png

 

Map

Screen Shot 2016-03-17 at 10.39.54 PM.png

Outcomes