https://community.qlik.com/t5/Connectivity-Data-Prep/Rename-Headers/m-p/1863278#M9892 <P>I have a direct connection to a SharePoint but when the data loads in XML the headers on the XML/data/row table come in with "ows_" verses a clean name. The xml/schema/elementtype table comes in with the "ows_" field and the clean name. How do I join the two tables so I can pull the rs:name to replace the data column headers?</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rubenacampos_0-1637780128276.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/67381i5AE25FC88021E678/image-size/medium?v=v2&amp;px=400" role="button" title="rubenacampos_0-1637780128276.png" alt="rubenacampos_0-1637780128276.png" /></span></P> <P>&nbsp;</P> Fri, 10 Dec 2021 21:06:16 GMT rubenacampos 2021-12-10T21:06:16Z https://community.qlik.com/t5/Connectivity-Data-Prep/Rename-Headers/m-p/1863278#M9892 <P>I have a direct connection to a SharePoint but when the data loads in XML the headers on the XML/data/row table come in with "ows_" verses a clean name. The xml/schema/elementtype table comes in with the "ows_" field and the clean name. How do I join the two tables so I can pull the rs:name to replace the data column headers?</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rubenacampos_0-1637780128276.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/67381i5AE25FC88021E678/image-size/medium?v=v2&amp;px=400" role="button" title="rubenacampos_0-1637780128276.png" alt="rubenacampos_0-1637780128276.png" /></span></P> <P>&nbsp;</P> Fri, 10 Dec 2021 21:06:16 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Rename-Headers/m-p/1863278#M9892 rubenacampos 2021-12-10T21:06:16Z