Forum Discussion

Tahir2061's avatar
Tahir2061
New Contributor III
4 years ago

Extract Metadata to Excel

HI All Does anyone know a way to extract a given Hierarchy to Excel broken out by columns for each layer ie a parent in one and children in the other. Using HFM in the past, I recall being able to ...
Excel Add In
marisolbritton's avatar
marisolbritton
New Contributor III

I tried your steps but when I mapped it it just showed blanks. 

 

SxD's avatar
SxD
New Contributor III
7 months ago

Hi Marisol - Not sure if you figured it out by now and maybe to help whoever else comes across this thread, but to get the parent child members to show in the table, you have to right click in the table Excel creates then go to XML > Import and it'll import from the file. The drag and drop exercise only creates the table layout.