Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I am loading data from excel and the load into QlikView loads with no errors BUT then when I check the table the values are all zero. I did check that the data is there on the actual load but still nothing is showing. I made sure the figures were formatted to numbers in excel also. Any hints as to what to check?
Any help appreciated.
you're welcome
Could you post screenshot, data, or your app?
!
can you see excel attachment?
check that it is accessing the correct excel sheet.
If you use the wizard to access the QV excel file, you see the data in the pantallacorrectamente?
Can you make a screenshot of the identification of the data?
Hi,
When I load data from xls file. I am able to see all data.
what issue you are facing??
I am using below script to load data.
data:
LOAD Team,
team_id,
role,
id,
Consultant,
July,
Aug,
[1/09/2015],
[1/10/2015],
[1/11/2015],
[1/12/2015],
[1/01/2016],
[1/02/2016],
[1/03/2016],
[1/04/2016],
[1/05/2016],
[1/06/2016]
FROM
[..\Desktop\Data.xlsx]
(ooxml, embedded labels, table is Sheet1);
Regards,
see this
Hi Enrique, yes I checked to see the data when loading it:-
should I be using a temp table to load the data first?
this is the script I'm using.:-
Concatenate(Facts)
LOAD Team,
team_id,
role,
id,
Consultant,
July,
Aug,
[1/09/2015],
[1/10/2015],
[1/11/2015],
[1/12/2015],
[1/01/2016],
[1/02/2016],
[1/03/2016],
[1/04/2016],
[1/05/2016],
[1/06/2016]
FROM
[..\Desktop\Data.xlsx]
(ooxml, embedded labels, table is Sheet1);