Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Very good Day!
I am preparing a monthly dash board which should show the monthly view of products in the table. I need to add the new month data to the existing app without affecting the current data. Also, the new month data should be shown in the table.
Kindly let me know if you need further details.
Can anyone help on this?
Store Qvd files Month on Month.
Ex: Product_MonthName_Year
Do Concatenation.
With Old data and with New Data.
Hi! Assuming that your files have the same structure, you could have a separate file for each month, e.g. 2019_01, 2019_02, etc.
Then just use wildcard to load them:
LOAD ... FROM [lib://Data/20*.xlsx]
They will concatenate automatically into one table.
Thanks for the reply!
But which is not working.... my file names are like this Jan 2019 - All Data, Feb 2019 - All Data.....
Put the files in one folder and go like this:
FROM [lib://Data/*.xlsx]
tried as mentioned above but it throws the error says that the Field is not available... but really the field is there in the excel source(and it is working if we do through data manager)
😞
this is the script which I have used:
LOAD
Region,
Country,
Entity,
Manufacturer,
"SSD Type",
"Host Name",
"Count / Count - Non Dispense",
"Location Type",
Model,
"Offline/Offline",
"Purchase Year",
"PC Core Year",
"Secure BIOS Manual Process Implemented"
FROM [lib://load from files/*.xlsx]
(ooxml, embedded labels, table is [Jan 2019]);
That's probably because of your list line:
(ooxml, embedded labels, table is [Jan 2019]);
This is the name of the tab in your Excel sheet. WIldcard would not work here. Every file should have the same tab name, e.g. Data.