Compare two records in Cloveretl

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • In Progress
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: EOL CLEANUP

I have two files, A and B. The records in both files share the same format and the first n characters of a record is its unique identifier. The record is of fixed length format and consists of m fields (field1, field2, field3, ...fieldm). File B contains new records and records in file A that have changed. How can I use cloverETL to determine which fields have changed in a record that appears in both files?

Also, how can I gather metrics on the frequency of changes for individual fiels. For example, I would like to know how many records had changes in fieldm

Photo of Lianamelissa

Lianamelissa

  • 2 Posts
  • 0 Reply Likes

Posted 11 months ago

  • 0
  • 1
Photo of Zach Sharpe

Zach Sharpe, Employee

  • 290 Posts
  • 32 Reply Likes
Good Afternoon! 

I wanted to reach out to clarify a few things here:

- Are the 2 files you are referring to exports from Emma? Are they files you are looking to import? 

- If they are exported from Emma, what type of export was it? Was it response data or audience data?

- While we don't support CloverETL first hand as an integration, I can hopefully help out with how you are looking to interact with Emma.

Let me know how I can help.

Thanks!

Zach