Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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