<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Import data from excel file with different headings. in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Import-data-from-excel-file-with-different-headings/m-p/2067909#M1223518</link>
    <description>&lt;P&gt;Yes, use "Load *".&amp;nbsp; If you want to process it as a crosstable, it would be:&lt;/P&gt;
&lt;P&gt;CrossTable(Month, Amount, 3)&lt;BR /&gt;LOAD *&lt;BR /&gt;From ...&lt;/P&gt;
&lt;P&gt;-Rob&lt;/P&gt;</description>
    <pubDate>Thu, 04 May 2023 23:15:01 GMT</pubDate>
    <dc:creator>rwunderlich</dc:creator>
    <dc:date>2023-05-04T23:15:01Z</dc:date>
    <item>
      <title>Import data from excel file with different headings.</title>
      <link>https://community.qlik.com/t5/QlikView/Import-data-from-excel-file-with-different-headings/m-p/2067897#M1223516</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;
&lt;P&gt;Is it possible to import this type of dataset into Qlik where you don't know what month the heading is going to be.&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Diinkant_0-1683239954746.png" style="width: 533px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/106502i633F586D164EB09F/image-dimensions/533x16?v=v2" width="533" height="16" role="button" title="Diinkant_0-1683239954746.png" alt="Diinkant_0-1683239954746.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;I will always know, Column A, B, C. But I won't know the month that appears from column D to O. It is a 12 month period so all 12 months will appear but it could be where D becomes Jun and O becomes May.&lt;/P&gt;
&lt;P&gt;Help if possible please.&lt;/P&gt;
&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Thu, 04 May 2023 22:41:48 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Import-data-from-excel-file-with-different-headings/m-p/2067897#M1223516</guid>
      <dc:creator>Diinkant</dc:creator>
      <dc:date>2023-05-04T22:41:48Z</dc:date>
    </item>
    <item>
      <title>Re: Import data from excel file with different headings.</title>
      <link>https://community.qlik.com/t5/QlikView/Import-data-from-excel-file-with-different-headings/m-p/2067909#M1223518</link>
      <description>&lt;P&gt;Yes, use "Load *".&amp;nbsp; If you want to process it as a crosstable, it would be:&lt;/P&gt;
&lt;P&gt;CrossTable(Month, Amount, 3)&lt;BR /&gt;LOAD *&lt;BR /&gt;From ...&lt;/P&gt;
&lt;P&gt;-Rob&lt;/P&gt;</description>
      <pubDate>Thu, 04 May 2023 23:15:01 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Import-data-from-excel-file-with-different-headings/m-p/2067909#M1223518</guid>
      <dc:creator>rwunderlich</dc:creator>
      <dc:date>2023-05-04T23:15:01Z</dc:date>
    </item>
  </channel>
</rss>

