Pivoting attribute-value pairs so the attributes become headers and the values under them

[hamdylie]

I need to join one attri-value paired table and one master table that contains the actual attribute name/header. The result is shown in Results window below.. but what I really want is to transpose/pivot the results so the column Right_ATTR_VALUE becomes the headers and ATTR_VALUE becomes the values under their corresponding headers..

Please advise how I can achieve the results I want.

My apology I cannot attach the workflow because the system rejects the content of the attachment doesn't match its file type (yxzp).

Thanks.

[jdunkerley79 · Accepted solution]

You need to use a Cross Tab to layout the data and then a dynamic rename to label the columns

Have attached a simple demo based on your screen shots

[s_pichaipillai]

go to the Transform Tool Menu and Drag and Drop the Cross Tab Tool

 then use Right Values as header  and Attr value as Data filed

test the attached workflow

[JoeM]

Removed solution. @jdunkerley79 posted it already!

[hamdylie]

Both solutions provided by jdunkerley79 or s_pichaipillai work depending which one one prefers. For me, I prefer 1st solution as it avoids the Join tool.

Thanks guys.