Remove Duplicates and keep the recent login Date from Two Columns

Hi

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.

image
image

Thank you

Regards
Narayanan.

Hi @narayanan

See Duplicate Row Filter – KNIME Community Hub

gr. Hans

2 Likes

Hi @narayanan,

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.

3 Likes

Hi,

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…

Thats it…

Thanks, BR…

Denis

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.