Maximum of the date value

I have two columns both date time format. Please suggest on How to do this

Max(Column1) < column2

I want to take only those data that matches the above criteria

Hey Rajesh,
The Max expression in Ataccama returns the greater of two operands, it can also work for datetime values. However, I do not understand how you want to get the greater value of just Column1. Can you explain your use case?

Regards,
Maksim

Hi Maksim,

This is coming form the History export.

We are exporting the history data so that we have audit of changes. But every time we export, we are overloading tables. Instead, we need to export only the delta changes that happened from teh last export hence this expectation.

Hey Rajesh,
You mention History export. I assume you are talking about MDC and not Ataccama ONE as you have selected for this question.
The History Plugin is used for keeping history of records in the hub. In the documentation about it there is a section for the batch export. It describes that you can limit batch export history by timeQuery. You could export only history versions valid from the date of the delta load run.

Regards,
Maksim