AnsweredAssumed Answered

How to convert dynamic header files into separate files using Key

Question asked by ukamble361217 on Aug 2, 2017
Latest reply on Mar 13, 2018 by ukamble361217

Here is the input file from client. Columns A-J are constant columns that we can add in flat file but if you see below my target columns K-R are going to get repeated multiple times and I dont know how many times. Client can have upto 12 sets of targets, sometimes less and sometimes more. How can I manage such data in boomi using flat file. How can convert this file into two file one with columns A-J and another file as Target file which will hold key value as userid+goal id.

image2017-8-2 16:57:37.png

Outcomes