Making DDT.CurrentDriver A Bit More Efficient
SOLVED- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
etc.
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
👍😁
