Forum Discussion

MarkSchofer's avatar
MarkSchofer
Frequent Contributor
4 years ago

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 No...
  • Marsha_R's avatar
    Marsha_R
    4 years ago

    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's avatar
Marsha_R
Moderator
4 years ago

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.

  • MarkSchofer's avatar
    MarkSchofer
    Frequent Contributor
    4 years ago

    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's avatar
      Marsha_R
      Moderator
      4 years ago

      👍😁