how to create one canonical item from two raw item

[Former Member]

hi experts,

I'm new to data hub. I would like to composite one canonical item from two different raw item. Is there any way to do that without custom hundler?

[former_member224482 · Accepted solution]

Simply provide multiple transformations.
Example :

 <item>
     <type>CanonicalAttribute</type>
     <attributes>
         <attribute>
             <name>attributeID</name>
             <transformations>
                 <transformation>
                     <rawSource>RawCHRMAS</rawSource>
                     <expression>E1CABNM-ATNAM</expression>
                 </transformation>
                 <transformation>
                     <rawSource>RawCLSMAS</rawSource>
                     <expression>E1KLAHM-E1KSMLM-ATNAM</expression>
                 </transformation>
             </transformations>
         </attribute>
         <attribute>
             <name>categoryType</name>
             <transformations>
                 <transformation>
                     <rawSource>RawCLSMAS</rawSource>
                     <expression>E1KLAHM-KLART</expression>
                 </transformation>
             </transformations>
         </attribute>
         <attribute>
             <name>attributeType</name>
             <transformations>
                 <transformation>
                     <rawSource>RawCHRMAS</rawSource>
                     <expression>E1CABNM-ATFOR</expression>
                 </transformation>
             </transformations>
         </attribute>
         ...

As you can see the categoryType is populated from RawCLSMAS and attributeType from RawCHRMAS while both raw are mapping the primaryKey field attributeID.

[Former Member · Accepted solution]

thank you Robin. I try multiple transformations and get back to you.

[Former Member · Accepted solution]

hi robin,

I could merge two raw item into one canonical. thanks you for your corporation!

[saket_chiluveru · Accepted solution]

Hi Robin,

in this case, would the attribute value be simply concatenated (without any concat character )?

[former_member224482 · Accepted solution]

No. Keys are matched, values are replaced, collections are appended.

[saket_chiluveru · Accepted solution]

To clarify, in the above example attributeID is mapped to E1CABNM-ATNAM & E1KLAHM-E1KSMLM-ATNAM. And if attributeID is not a collection i.e. a single valued field then then the value will be the second attribute E1KLAHM-E1KSMLM-ATNAM. Is that correct ? If E1CABNM-ATNAM = "A" and E1KLAHM-E1KSMLM-ATNAM="", then attributeID = "".