Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hei check this example
hope its helps you
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
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...