New reply on DataCleaner's online discussion forum (https://datacleaner.org/forum):
Dennis replied to subject 'How to write the Preview Data available on Merge Duplicates component?' ------------------- Hi Renato, This is not really simple, as they'll be in their own rows, and DataCleaner mostly works on a row-by-row basis. You'll probably need to do it in multiple jobs: Include the group ID and status, then write it to a temporary file. In a new job you can then filter on the status, picking all the non-survivor states, and then use the table lookup on the same file to find the master term of the group id (you can use an expression-based column to easily filter the survivor records). Then you can write the new output data from the original and lookup-up column. Hope that helps! BR, Dennis ------------------- View the topic online to reply - go to https://datacleaner.org/topic/1161/How-to-write-the-Preview-Data-available-on-Merge-Duplicates-component%3F -- You received this message because you are subscribed to the Google Groups "DataCleaner-notify" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/datacleaner-notify. For more options, visit https://groups.google.com/d/optout.
