This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have the following table from an Excel:
The thing is that I have many columns (each one is repeated by Budget or Actual).
Is there any way to transpose the table in order to have something like this? (and would it be better to handle this way??)
Or would it be better to use it as I get it? (I only put 3 metrics for this demo, but I actually have like 7 or 😎
Thanks in advance!!
Try this script to load your data
LOADPERIOD,HOTEL," ROOMS_AVAILABLE_BUDGET "," ROOMS_AVAILABLE_ACTUAL "," ROOMS_OCUPPIED_BUDGET "," ROOMS_OCCUPIED_ACTUAL "," ROOM_SALES_BUDGET "," ROOM_SALES_ACTUAL "FROM [lib://AttachedFiles/0109.xlsx](ooxml, embedded labels, table is Sheet1);
FinalData:LoadPERIOD,HOTEL,Mid(Metrics,1,Index(Metrics,'_',2)-1) as "Metrics",Mid(Metrics,Index(Metrics,'_',2)+1) as "Type",ValueResident tmpData;
drop Table tmpData;
Hope this helps