Compare two records in Cloveretl

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress

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 5 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