Concatenate Tab1 data from 2014,2015,2016 - Page 3 - Qlik Community

Anonymous · ‎2015-11-02

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

Anonymous · ‎2015-11-02

LOAD [Audit Date],

[DEA or NABP Number],

[Pharmacy ID],

[Pharmacy Name],

Address,

City,

State,

PharmacyTYpe,

LeadAuditor,

AuditType,

AccountManagerName,

MAAccountDirector,

[Product Audited],

[Overall Audit Result],

[Observation Rating],

[Observation Yes or No],

[Repeat Observations],

[Tier 1],

[Tier 2],

[Number of Counselors],

[Date Audit Report Issued],

[Date Response Received],

//[Date Certificate sent],

[Effectiveness Check],

Comments

FROM

----------------The same thing I told u

(ooxml, embedded labels, table is [Audit Stats Tracking]);

Its working..

Anonymous · ‎2015-11-02

It seems one or two column are not common, so you can comment them if not required.

Anonymous · ‎2015-11-02

PFA..

Anonymous · ‎2015-11-02

Actually i removed Year in tab name

need to add Year 2014 ,2015 for 2 tabs

they are not agreed to remove year in tab names

2014 Audit Stats Tracking,

2015 Audit Stats Tracking