Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Importing specific named tables from excel and then cross table

Hi,

im going to start using weather data, and it comes in this format per month in the same file. Lets call it weather.xls.

 

Element123456789101112131415161718192021222324252627282930
Normal TAM12,412,512,612,712,812,812,9131313,113,113,213,313,313,413,413,413,513,513,613,613,613,713,713,713,813,813,813,913,9
TAM13,416,920,418,718,119,314,414,61212,213,514,715,717,61917,616,614,51212,314,51616,515,614,815,3
RR1,520000000012,800000,30,30011,80,400,210,30,37,8

I've made named fields inside the excel file:

January2016

February2016

March2016

April2016

May2016

June2016

....

What i want to do:

1. Read only the tablenames in the list above.

2. Cross table the day of the month (1-30/31).

3. End result cross table: get a vertical list of normal TAM, TAM, RR with the corresponding day of the month. (1,2,3,4,5,6,7).

 

ElementNormal TAMTAMRR
112,413,41,5
212,516,92
312,620,40

4. Add for each filelist [lib://desktop/weather*.xls] including the specific table names and cross table function.

I've only done cross table with two rows before and i don't know how to use import a named list of table names from excel file.

Hope you can help me out on this one.

Thanks,

1 Reply
vikasmahajan
Honored Contributor III

Re: Importing specific named tables from excel and then cross table

hope this helps you The Generic Load

Vikas