Making DDT.CurrentDriver A Bit More Efficient
I am using DDT.CurrentDriver (PYTHON) -It works fine but loses its way occasionally
Reading from a spreadsheet in Loops
I read from a the spreadsheet get an EMPID, Check amount and a check date
Now that I am later in the year I read multiple times for each individual (EMPIDS)
Instead of reading and evaluating once for each month (EMPID, DATE,AMT)
I would like to loop through with the EMPID and lookup up all nine values at once.
My brain hurts. IN SQL I know how to accomplish this, however in Python (Or a wild manipulation of EXCEL) I would like to only do one pass of the data instead of one for each month.
Solved! Go to Solution.
I've never seen DDT.CurrentDriver lose its way, so not sure what that could be other than maybe there is a blank cell in the way and it will stop there.
If you want one emp = one pass then put all the data for one employee on the same line
EMPID DATE1 AMT1 DATE2 AMT2 DATE3 AMT3
Thanks Again ......yes that what I was hinting at, doing the manipulation in Excel, then I end up mucking with the original data.
I was hoping for a Python solution but .....I think you are right. And I as typed a response an alternative that is somewhere in between is
using a database solution (Access), SQL Server and then it is one simple select statement.
Thanks once again for thinking outside the box.