having several website I have several files. they have the same structure.
How to concatenate the data use the same filters (particularly for the sites, dates, labels) and accumulate the data quantity and amount in the same graphics?
If you have multiple data files with same structure and same extension (e.g. .qvd or .xls or .csv) then use below syntax:
FROM ..\Data\*.qvd (qvd);
This will load all of the QVD files into Data table.
Hope this will be helpful.
Well no!The file formats are not the same.Moreover, some columns are not the same in different files.
Thank you for your inputs. Would it possible to share some sample data along with current situation and expected results. This will help us further analyze this issue.
how can I you address files?
Retrieving data ...