Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi Guru's
i have 3 Excel sheets
1.2014 Sales
2.2015 sales
3.2016 Sales
in future it may add 2017,2018,........
Each excel contains 2 Tabs.
1.Say TAB1
2.Say TAB2
i want to load Automatically these excel data
Concatenate TAB1 Data in each excel Sheet and store as one QVD.
Similarly
Concatenate TAB2 Data in each excel Sheet and store as one QVD.
How to achieve this.
Any Help would be greately Appreciated
Thanks in Advance
Two simple things you need to do:
1) Make sure all are at one common place
2) Naming of Excel file should be common
like 2015.xslx, 2016.xslx,2017.xslx etc
Then use following code for Asia:
ASIA:
LOAD Year,
Sales
FROM
---------this astrik sign for last digit
(ooxml, embedded labels, table is ASIA);
QV will automatically fetch all the Asia data from multiple Excel files...
hi balraj,
Your approach is gud
But My excel names are 2014 sales Report,2015 sales report
Tab Names are 2014 Asia sales,2015 Asia Sales
like above
how to use wild card search in Table name and sheet name
This should work in your case...
(ooxml, embedded labels, table is [2014 Asia sales]);
any challenge you are facing?
above statement inplace of 2014 i have to give Wildsearch means *
[2014 Asia sales] - is name of Tab for Asia sales in your [2014 Sales Report] excel.
201* means any file started with 201 it should fetch.
Make sure your tab name should be same in each and every excel.
Hi ,
But they want to keep Year before each tab
thats the problem
Could you share their two excel sheets of any two years?
Let me finish it.
these are the actual excels
sheet name is 2014 Audit Stats Tracking,
2015 Audit Stats Tracking
Which tab of both for Asia is common??
ASIA and USA i mentioned for example
here
2014 Audit Stats Tracking,
tabs is common in two excels
