Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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?
Bruno
Hello Bruno,
If you have multiple data files with same structure and same extension (e.g. .qvd or .xls or .csv) then use below syntax:
Data:
LOAD *
FROM ..\Data\*.qvd (qvd);
This will load all of the QVD files into Data table.
Hope this will be helpful.
Regards!
Rahul
Hello
Well no!
The file formats are not the same.
Moreover, some columns are not the same in different files.
Regards
Hello Bruno,
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.
Regards!
Rahul
Yes,
how can I you address files?