Email to support

Hi - I sent an email with attachments to the support email address last night. The issue is related to getting different results depending on the transformation / package being run with all records versus being run with one record. Hoping you will have a chance to look at this soon.

We have your email and we will try to reproduce the problem later today.

Peter

From time to time we have to sleep...

Sleep!! Highly underrated!!

Works fine here

SQL used for lookup is a source for potential problem

Select
joblabor.jobid,
Sum(joblabor.totalcost) As totalcost,
Sum(joblabor.totalsoldprice) As totalsoldprice,
Sum(joblabor.totalsoldpricetax) As totalsoldpricetax,
Sum(joblabor.quantity) As quantity,
joblabor.taxable
From
joblabor
Group By
joblabor.jobid, joblabor.taxable


lookup assumes that unique id is jobid

You sql can have duplicates.

For example you can have taxable non taxable record

Which record shall lookup return?

jobid,totalcost,totalsoldprice,totalsoldpricetax,quantity,taxable
1,12,13,14,15,1 <= record 1 is taxable
1,22,23,24,25,0 <= record 2 is not taxable

Mike

PS we definitely need search function ....

Mike

Hmm - I thought I had that fixed. Maybe in another transformation. The source data is very bad which has contributed to the mess in my transformations. Plus this was my first project using AETL. I feel that my transformations are a mess but do not know how to fix that and do what needs to be done. One thing I have seen in other tools is the ability to have sub transformations - for example when you need to have is null, is empty, a calculation or three between the source and target - be able to put those is a sub transformation object so that there would just be the links from source and to target and inside that object would be the other transformations.

Thanks for seeing the need for search. I do not know if my transformations are more complex than the average or what - but search would be a big help. There are a few other canvas suggestions I have that I think would help - but those are for another day.