Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
cseward1963
Contributor

Re: manually Link tables and/or designate key fields

I use qlik sense cloud.  I've imported the spreadsheet to "My Data Files".  Can you tell me how I alter this part of the script so the source file can be found?

FROM [lib://source/Qlik Centennial Indiv test.xlsx]

omarbensalem
Esteemed Contributor

Re: manually Link tables and/or designate key fields

If you laod data through the load editor, you have to prepare data, drag and drop the bubbles (technically the tables) above each other to make associations (and choose the field; Sense will propose associations for you); then reload:

Capture.PNG

Capture.PNG

Capture.PNG

If you already know your source and do not need any help form qlik to help you modelise, please choose to load data through the script.

If your question has been answered, please close this thread by marking the correct answer as so and the hepful ones as helpful (under actions, buttom left)

Thanks,

cseward1963
Contributor

Re: manually Link tables and/or designate key fields

Never mind my last question.