I am trying to carve up one big text file that has trial balances for multiple entities. The goal is to read that one big file, and write each trial balance to its own file.
I have added a row index for each row in the "master" file. I can also dynamically generate a table that tells me the row at which each entities data starts,
My first idea was to somehow combine this table with the master file so that I could tag rows with entity id A/B/C through a formula tool. I could then generate a filename for each entity id and store the appropriate rows in each file with an output tool.
But, I dont know how to combine the data from the master file and my index table such that I am able to do what I want. As always, I'd appreciate the Communities help.
