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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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