2 Replies Latest reply: Oct 11, 2016 4:26 AM by Maria Sandorova RSS

    Insert from excel, month issue calendar

    Marius August Larsen

      hi, i try to insert table files from excel.

       

      how can i link the months in my excelfile to my calendar?

      in each month there is a number value that show the sum for that month.

       

      the other tables that i have linked in earlyer has a datefield so i used the %DateKey, but i dont know how to connect the month without getting a script error Field names must be unique within table.

       

      left join

      LOAD Kommune,

           F2,

           Stasjon,

           F4 as MålepunktnavnTemp,

           normalperiode,

           Jan,

           Feb,

           Mar,

           Apr,

           Mai,

           Jun,

           Jul,

           Aug,

           Sep,

           Okt,

           Nov,

           Des,

           sum

      FROM

      [D:\QlikView\QlikView Storage\9_Excel\Graddag\Normalår Måned for Måned.xlsx]

      (ooxml, embedded labels, header is 2 lines, table is [01  Østfold]);