WF component: TransactionAggregator, error handling Timezone column #131
Description
Email from user: "I am trying to .... use the Transaction Aggregator component to roll it up to run AFM. The Transaction Aggregator is reporting: Conversion of Time column to UTC time zone failed. I've double checked that it's not that excel screwed up the time stamps. The workflow I'm using is: https://pslcdatashop.web.cmu.edu/LearnSphere?workflowId=2162 and I've attached the data file I'm tryin to use."
Email from developer: I was able to get it to run with your file by removing the 'Time Zone' column. .... looking at the python code, the error you saw is generated when trying to handle more than one time zone value in that column. Your data has two different time zone values but both are basically EST so I figured it was safe to remove the column.