Updating records using UuidCreate() and MD5_UNICODE data

I hope I could understand your demand. Please see the attached workflow. It might be not exactly what you want to do, but at least it should be something that you can start with.

120282_gawa.yxmd

narula8

Hello Gawa,

Excellent, this is really helpful. Much appreciated.

However, I quick question on sample workflow provided.

Instead of comparing Value 1 and Value 2 , it would be ideal to compare "Uuid" and "MD5" fields.

In my case, I have more than 10 value fields and wouldn't' be ideal to compare field by field right ??

Also planning to update status using information available in - https://www.theinformationlab.co.uk/2015/07/03/slowly-changing-dimensions-in-alteryx/

gawa

@narula8

If you have many fields to be compared, transpose data into vertical shape, then compare by JOIN tool.

By doing so, you can always compare the field "Name" and "Value" in JOIN tool.

This is some tips we frequently use for comparison of dynamic fields. See attached revised WF.

Please finish your task with reference to attached WF. Good luck!

120282_gawa_REV1.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335