1.0Gathering Tools - Improve the reliability and security of Excel processeshttps://www.gathering-tools.com/en/rich600338<blockquote class="wp-embedded-content" data-secret="T3Etmk7ePo"><a href="https://www.gathering-tools.com/en/documentation/pivot-import-mechanism/">pivot import mechanism</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.gathering-tools.com/en/documentation/pivot-import-mechanism/embed/#?secret=T3Etmk7ePo" width="600" height="338" title="“pivot import mechanism” — Gathering Tools - Improve the reliability and security of Excel processes" data-secret="T3Etmk7ePo" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script> /*! This file is auto-generated */ !function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document); //# sourceURL=https://www.gathering-tools.com/wp-includes/js/wp-embed.min.js </script> Details of the pivot import mechanism Pivot import removes existing records and replaces them with input records (from the form compartment). The import pivot fields define the combinations of items that designate the data to be replaced in the host table. The records corresponding to the “pivot combinations” in the host table are deleted and […]https://www.gathering-tools.com/wp-content/uploads/2021/11/PivotAxis11.png818746