Skip to Content
Former Member
Aug 26, 2014 at 10:03 AM

Data Hub: Transform multiple raw attributes into single canonical attribute


Resources that I'm using to test the scenario described below:

  • Data Hub 5.2

  • pcm-apparel-

  • csv-web-service-


  • My Raw Item "RawProduct" has two attributes: category and brand

  • My Canonical Item "CanonicalProduct" has an attribute: category

  • My Target Item "ApparelProduct" has an attribute: superCategories

I want to gather the values of "category" and "brand" attributes from RawProduct into the "category" attribute of my CanonicalProduct, later the attribute "superCategories" from ApparelProduct will be populated using the "category" attribute of my CanonicalProduct.

What's the best way to do it?

  • I thought about some solution using Grouping handlers (but maybe it's too much for such an easy task):

  • Maybe some SpEL expression to "combine" both attributes into a single attribute from Canonical item to Target item using "transformationExpression", but is it possible to do it with collection attributes?

  • Maybe I'm skipping some easier solution such as any specific attribute setup via XML.