Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
homee
Contributor III
Contributor III

Loading a .csv --> Data currently not available

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?

Labels (3)
7 Replies
Qlik1_User1
Specialist
Specialist

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.

homee
Contributor III
Contributor III
Author

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. 

Qlik1_User1
Specialist
Specialist

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.

homee
Contributor III
Contributor III
Author

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:

The following error occurred:
Circular reference: One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. Loop(s) will automatically be cut by setting one or more tables as loosely coupled. Use Loosen Table script statement to explicitly declare loosely coupled tables.: return
 
The error occurred here:
Search index creation completed successfully
homee
Contributor III
Contributor III
Author

Okay, it seemed that the "description" field caused a problem. 

Thanks for your help

lanlizgu
Creator III
Creator III

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

Qlik1_User1
Specialist
Specialist

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.