Merging data with rules.

bk2 — Sat, 16 Nov 2024 07:27:06 GMT

Hello,

I would like to merge data from multiple sources with intention to create one 'golden record'.

I'm looking for some advice how to achive workflow solution that will automatically select and pass fields based on rules.

Example data to merge:

Data Source: 01.xml

Node ID: 001

Node Description: Lorem ipsum dolor sit amet

Node Photos: 001.jpg, 002.jpg

Data Source: 02.xml

Node ID: 001

Node Description: Lorem ipsum dolor sit amet, consectetur adipiscing elit

Node Photos: abc.jpg

Rule for Node Description field: select longest string

Rule for Node Photos: select source with more values (photos)

So after all my 'golden record' should be:

Node ID: 001

Node Description: Lorem ipsum dolor sit amet, consectetur adipiscing elit

Node Photos: 001.jpg, 002.jpg

I'm on Open Studio.

Regards,

Bart

Re: Merging data with rules.

Anonymous — Thu, 25 Oct 2018 08:26:22 GMT

Hello,

From your description, we have designed a demo job for you.

Let us know if it is OK with you.

Please have a look at my screenshots for details.

Best regards

Sabrina