Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i loaded a .csv in several ways into QlikSense it appears in the Data Manager but it shows an error "Data currently not available".
Can somebody tell me how to solve this?
Go to script editor--> click on connection on top right -->select the folder location and provide the name to that location-->now select the file--> reload
You will see the excel data loaded in data model.
Hi, it works when i load into a new app but it still isn't available when i want to add it to an app that already has data from other sources.
Sorry buddy didn't get you completely. It will be good ,if you can share the script you are using and screen shots as well.
I have added these lines to my load script in the Data Load Editor and i am getting the following error. And the data model doesn't work anymore.
Code:
LIB CONNECT TO 'homee-Daten:Google_Drive - mailadress';
LOAD
description,
"Date",
Forecast,
group_id AS id
FROM [lib://homee-Daten:Google_Drive -mailadress/root/FC1-2020.xlsx]
(ooxml, embedded labels, table is Sheet1);
Error:
Okay, it seemed that the "description" field caused a problem.
Thanks for your help
Is this the full script?
It seems that you are loading multiple Excels with the same structure, and instead of using concatenate to join these Excels, you are creating as many tables as Excels with the same estructure, generating circular references (the system tries to link these Excels and as it has many times the same field it generates circular references).
Thank you
As per error circular references got created, so try to get rid of circular references and than run.
If possible share the complete script you are using and data model as well.