Hi @kashtech, Your dataset's field values and the expected output field values are not seeming to be in sync. For example: - Dataset that you shared: - name='name1', user='abc', type='type1', other-fields : latest event name='name1', user='abc1', type='type1', other-fields : past event name='name2', user='def', type='type2', other-fields Here, the two distinct values for field "type" are: - type1 and type2. However, in your expected result, the value of field "type" is new. name='xyz', user='abc', type='new', other-fields name='name2', user='def', type='type2', other-fields Thus, for clarity it would be helpful if you could share the dataset: - 1. in tabular format 2. in sync between input and expected output. Thank you
... View more