Ask a Question

Making DDT.CurrentDriver A Bit More Efficient

SOLVED
MarkSchofer
Frequent Contributor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Marsha_R
Community Hero

Re: Making DDT.CurrentDriver A Bit More Efficient

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.

Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame

View solution in original post

3 REPLIES 3
Marsha_R
Community Hero

Re: Making DDT.CurrentDriver A Bit More Efficient

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.

Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame

View solution in original post

MarkSchofer
Frequent Contributor

Re: Making DDT.CurrentDriver A Bit More Efficient

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. 

Marsha_R
Community Hero

Re: Making DDT.CurrentDriver A Bit More Efficient

👍😁

Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
cancel
Showing results for 
Search instead for 
Did you mean: