topic Dynamic Names and Table Pivot: How can I get the following output? in Getting Data In https://community.splunk.com/t5/Getting-Data-In/Dynamic-Names-and-Table-Pivot-How-can-I-get-the-following-output/m-p/447613#M77835 <P>Hi,</P> <P>I have a single CSV source where the columns names are not fixed as well as the number of the columns. A simple search returns the following:</P> <P><span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/5723iACDEFF2F40C14741/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> <P>The number and the letter after the string PhysicalDisk is variable. I'm calculating the avg() and perc95() for each value.</P> <P>How can I get the following output from this source, where the Instance is part of the original field name?</P> <P><span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/5724iCE7872EDEAC90139/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> Mon, 10 Sep 2018 15:36:40 GMT tamakg 2018-09-10T15:36:40Z Dynamic Names and Table Pivot: How can I get the following output? https://community.splunk.com/t5/Getting-Data-In/Dynamic-Names-and-Table-Pivot-How-can-I-get-the-following-output/m-p/447613#M77835 <P>Hi,</P> <P>I have a single CSV source where the columns names are not fixed as well as the number of the columns. A simple search returns the following:</P> <P><span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/5723iACDEFF2F40C14741/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> <P>The number and the letter after the string PhysicalDisk is variable. I'm calculating the avg() and perc95() for each value.</P> <P>How can I get the following output from this source, where the Instance is part of the original field name?</P> <P><span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/5724iCE7872EDEAC90139/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> Mon, 10 Sep 2018 15:36:40 GMT https://community.splunk.com/t5/Getting-Data-In/Dynamic-Names-and-Table-Pivot-How-can-I-get-the-following-output/m-p/447613#M77835 tamakg 2018-09-10T15:36:40Z