AnsweredAssumed Answered

How to pick effected data.

Question asked by jeevitha.kamireddy175371 on Jun 12, 2018
Latest reply on Jun 15, 2018 by mathew.kumpalamthanam417102

Hi All,

 

I have 3 fields date, Amount and Frequency. I am picking history record with same id. If any amount or frequency change then we need to send that record. Could you please help me.

For example.

Input:

id, date, Amount, Frequency

1,2018-06-06,12,0303

1,2018-05-31,12,0303

1,2018-05-29, 15,0303

 

Output:

id, date, Amount, Frequency

1,2018-05-31,12,0303

 

Thanks,

Jeevitha Kamireddy.

Outcomes