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.