Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
krengan21
Creator
Creator

Talend calculation


How to get the actual value from the cummulative value in talend ? for example On a paricular a car runs for 1000 kms next day the car will start from 1001 kms ,So what i need is how to calculate the total kms covered on a particular day

1000kms on 27-10-2017 2000kms on 28-10-2017

so the total kms covered on 28-10-2017 is 1000kms how to do that in talend for which i need to update around 1 lakh history records using the above method and this needs to be done in mongodb

Labels (2)
11 Replies
krengan21
Creator
Creator
Author

11569|1
27752|1
27797|1

 

this is the output i am getting instead of the expected one.

The expression used are as follows

Var.lastDistance!=null ? row1.distance - Var.lastDistance : row1.distance  for today distance 

row1.distance  for last distance

Please tell me what is the issue

 

Anonymous
Not applicable

I need a screenshot of your tMap config