Harmonizing step setup

M.Lambert
M.Lambert Contributor

Hi there,

I was trying to create a priority on the harmonizing step to choose an email based on a score but it's not working. I checked everything to see what's wrong but couldn't find anything, can you help me? I am using the same rules on other fields for example to choose the most recent phone and address on the interaction date field and it's working well. Any ideas?

Tagged:

Best Answer

  • Henry Simms
    Henry Simms Administrator
    Answer ✓

    When I've had problems with score based priority before, its been because the score column's datatype wasn't what I expected. If it's supposed to be a numeric value, it may actually have Alphanumeric datatype. Try converting to number in a transform step before the Harmonize.

Answers

  • M.Lambert
    M.Lambert Contributor

    Hey Henry,

    That was spot on, all fixed now!

    Thanks a lot