Can you help to assist how to remove duplicates from two columns and keep the last login date from the table.
Tried using Rule engine/Rule based Row filter but couldn’t get the exact expression to remove duplicates and keep the last.
1- Convert “Last Login Date” to Date type by using the String to Date&Time node. (Date format: d/M/yyyy)
2- Use the Duplicate Row Filter node to remove the duplicate rows. For this, in the configuration dialog of the node, include the “Email ID” column and then in the “Advanced” tab, select “Maximum of” the “Last Login Date” column.
If the column is date format, just sort as descent order and groupby node to set emails as major info and date to show only the first info…
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.