Insert from excel, month issue calendar

[Anonymous]

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

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

[JaMajka1]

Hello,

try to use corsstable() function in your script - months will become one regular dimension as if they were in rows not in columns. https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/ScriptPrefixes/crosstable.htm

Maria

[marcus_sommer]

Load your excel with The Crosstable Load and afterwards you could convert your month with makedate() to a date.

- Marcus