Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Excel script transform file

Hi everyone,

I'm trying to load a table from excel without having to modify QlikView from outside.

I know it can transform from loading tables but can not. I've looked at the reference manual but it is nothing.

Let's see if anyone can lend a hand.

The example of excel file.

Thanks.

Tags (2)
1 Solution

Accepted Solutions
lironbaram
Honored Contributor II

Re: Excel script transform file

hei check this example

hope its helps you

3 Replies
lironbaram
Honored Contributor II

Re: Excel script transform file

hei check this example

hope its helps you

Not applicable

Excel script transform file

Hi,

how did you do?

I tried to do with the cross table but I could not, can you tell me a little guide?

Thank you very much

martinpedersen
Contributor

Re: Excel script transform file

I think you should use "Crosstable" to allow you transform the data durring the load script:

(First I have renamed column A in the excel sheet to Date but could have used the "@1" instead). Then the load script should be something like:

CrossTable(Terminal, Sales, 1)

LOAD Date(Date, 'dd-mm-yyyy') as Date,

     [1],

     [2],

     [3],

     [4],

     [5],

     [6],

     [7],

     [8],

     [9],

     [10],

     [11],

     [12]

FROM

[..Libro1.xlsx]

(ooxml, embedded labels, table is ventas);

To explain the crosstable function you can use the help function in the script editor. But in this exampe I configured it to have all the columns included in the field "Terminal", and the values as Sales. The 1 is refering to that the first column should be a field - and not included in the cross table. Hope that will do the trick for you...