Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have the following problem, in Qlik I do not know how to change the format of my TEST file, to obtain as a result the form that comes in the image below.
Thank you for your attention.
you want to transpose whole table ,right ? try this
LOAD * FROM
TEST.xlsx
(ooxml, embedded labels, table is Hoja1, filters(Transpose()));
How do you want the rows with per hour numbers to be handled? Will a pure transpose work for you?
Normally an Unpivot would be the better representation/transformation for a BI application.
Hi Dave, send me this message error.
Thank you for help me.
Hi Petter, i try to preserve the format of file TEST on Qlik, because the row FECHA=DATE will be the header after transpose and date is the master measure.
I try with Unpivot but, i can´t obtain the result.
Thank you for the help.
Best regards
PM
How about Load * ?
it looks ok in my side
Fast and esy Dave.
Thank you for the help