Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've created a dashboard and I've got a number of monthly files in the load statement, e.g. :
[201605 Customers May 2016]:
LOAD [Customer_ID]
,[Customer Name]
,[Transaction Date]
,MonthName([Transaction Date]) as 'Transaction Month'
FROM [lib://AttachedFiles/201605 Customers May 2016.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
[201606 Customers June 2016]:
LOAD [Customer_ID]
,[Customer Name]
,[Transaction Date]
,MonthName([Transaction Date]) as 'Transaction Month'
FROM [lib://AttachedFiles/201606 Customers June 2016.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Some dates were incorrect in one month, e.g. May, and I manually corrected them in the .csv file, but when I try and 'Load' them again using the Data Load Editor, the dashboard is not updating with the new data and maintaining the old file contents. How can I get it to point at the newer dataset?
Many thanks,
Sarah
It looks like you are not getting the updated data because your connection to the file is not correct.
Where do you store your updated .csv? Is it the same place like your referenced lib:?
To check if you are pointing to the right file go to Data Load Script - > Data connections and click on Selected data icon.
Please check in base data.
Also you can store data in qvd and and then use that qvd in final dashboard
Hi Tereza,
many thanks for that - yes I changed the location of the files and saved them on the Remote Desktop Connection for Qlik Sense Server: C:\Qlik\Files\My Folder and changed the location in the script:
[201605 Customers May 2016]:
LOAD [Customer_ID]
,[Customer Name]
,[Transaction Date]
,MonthName([Transaction Date]) as 'Transaction Month'
FROM [lib://My Folder 201605 HR Med.Group May 2016.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
This seems to work well now.
Thanks again,
Sarah