Updating records using UuidCreate() and MD5_UNICODE data

[narula8]

Hello Experts,

I am generating unquie records using UuidCreate() and MD5_UNICODE  as below.

 using MD5 column, I want to update data from layer-1 to layer-2.

day 1 - 1st records moved from layer-1 to layer-2.

day 2 - as we have new id in MD5, I want to move second record and flag it as updated in layer 2.

Any advice is appreciated.

[gawa]

@narula8 

In order to make it more clear on your demand, can you show how data looks like for day1 and day 2, or provide data BEFORE and AFTER?

[narula8]

Hello gawa.

Thanks for quick response.

Attached screenshot has day1 and day 2 record details.

On day 1 , as it is a start load I want flag Record_Status= New

On day2 , as the record changes we have a new MD5 code.

Kindly note MD5 code is generated using MD5_UNICODE(String) .

String is the concatenation of required fields. 

As we have change record  I want to insert a new row and flag it as Record_Status = Updated 

and earlier record  to be updated as old.

Hope I am able to explain my requirement. 

[narula8]

Hello Gawa,
I have a attached updated screenshot for more insights of my request.

Hope it helps.

[narula8]

Hello Gawa,

Sorry ignore above and please refer below sreenshot.

 

[gawa]

hi @narula8 

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.

[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!