Log In
Register
Home
Active Member
May 26, 2024
Offline
I have a similar situation that was covered in the post below but am having issues when I want to use a File Folder as the Data Source. For clarity and brevity, I will restate my issue.
I get multiple payroll files for several entities and am trying to make a master list of combinations of Employer Number, Distribution, and Large Account, which is the pay code. Eventually, I will link this master code to a GL string. I will add sample files here, along with a desired output. Essentially, each payroll file has 2 tables of data, the first table, Table1, is a two-row table with the needed Employer number. The second table, say Table2, is separated by a blank row, then contains various columns of information, and I really only need a merged column of the Distribution to the Large Account.
My replies to the thread below detail some of my attempts that have not worked. As new payrolls are run and files generated, I wanted to be able to drop these files in the source Folder and have it update the output.
Hope this is clear and any help appreciated.
Moderators
January 31, 2022
Offline
Please see attached. It includes three possible solutions for the basic transformation steps. One is based on the example given by Velouria in the thread you referred to. The other two show how you can get the Employer Number on every row in the bottom part of the table. The first uses an index column, finds the row that has "Employer number" in the first column and then picks-up the value from one row below. However, if the Employer number is always on the second row of the first column, you can create a variable from it directly and use it in an 'Add custom column' step.
Come back here if you get stuck.
1 Guest(s)
