- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to load data from multiple table with single load statement.
We have 4 tables named A1,A2,A3 and A4 , here all 4 tables having same data then How we load all 4 tables in a single load statement. If its possible or any one know please help me out.
Thanks in advance
Debabrata
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just use wildcard in your load statement as follows:
TableName:
Load A, B, C, D FROM A*.XLSX;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If data format is csv or xslx or xls or qvd, and all the files are in the same catalog then simple use
From *.xslx as mentioned above:
LOAD *
From
[C:\5.Data\*.qvd]
(qvd)
;
If the source is different than "it depends" 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just use wildcard in your load statement as follows:
TableName:
Load A, B, C, D FROM A*.XLSX;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It doesn't work with xlsx, I tried it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Are all the tables in the same workbook on different sheets or are they all independent files?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If data format is csv or xslx or xls or qvd, and all the files are in the same catalog then simple use
From *.xslx as mentioned above:
LOAD *
From
[C:\5.Data\*.qvd]
(qvd)
;
If the source is different than "it depends" 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It really does work 🙂
This is my load script, it loads three files called a1.xlsx, a2.xlsx and a3.xlsx
LOAD A, B
FROM [Z:\a*.xlsx] (ooxml, no labels, table is Sheet1);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes its working on multiple excel file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if A1,A2,A3 and A4 will different sheet of one excel file then what we have to do.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content