Concatenate Tab1 data from 2014,2015,2016

[Anonymous]

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

i want to load Automatically these excel data

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

[SreeniJD]

Hi Are Babu

Check this thread

Loading Multiple Excel Sheets Dynamically along with file name and sheet name

[mayankraoka]

Hi,

Please check this:

Storing all tables in Qlikview file to QVD

Regards,

Mayank

[Anonymous]

You need to create Two tables Tab1 for all year and Tab2 for all year

[Anonymous]

Hi Sreeni,

Thanks for Helpful Answer

But in each Excel i have 2 Tabs.

1.ASIA

2.USA

i want to create 2 QVDS .

means concatenate 2014 ASIA + 2015 ASIA +2016 ASIA and Store as QVD

similarly for USA

1 for ASIA

2 for USA

please find the attached sample data and Application

Thanks !@

[Anonymous]

ASIA:

LOAD Year,

     Sales

FROM

(ooxml, embedded labels, table is ASIA);

concatenate

LOAD Year,

     Sales

FROM

(ooxml, embedded labels, table is ASIA);   and so on....

Similar for USA....

[Anonymous]

hi Balraj ,

you are right

But how to automate and store as QVD

Thanks

[Anonymous]

For further increasing in excel sheet like as you said you may get 2017,2018....

Create a loop for all with like as you shared if format is like 2015.xlsx,2016.xslx,2017.xslx

then you can write like this:

ASIA:

LOAD Year,

     Sales

FROM

---------this astrik sign for last deegit

(ooxml, embedded labels, table is ASIA);

[Anonymous]

In future the EXCEL Sheets may added

so we have to automate the load

[SreeniJD]

Hi

The best practice is have all your source files in one folder and mention the same path in your script to all the available excel sheets and you can also name the tables as a source excel file. Storing in to QVDs is just an additional step to your script..

LOAD *

FROM

[Path\*.xlsx]

STORE into .....

Sreeni