Append from multiple tabs

[Anonymous]

Hi,

gwassenaar‌ jagan‌ swuehl‌ tresesco‌ msolomov‌

I need to append data from multiple tabs in excel into a single file, the field names are the same, attaching the sample file with 3 tabs. Final output should have 9 names with 9 SSOs.

Can anyone guide me on how to do that?

Thanks

Sunny

[robert_mika]

Directory;

LOAD Emp,

     SSO

FROM

[Append Test.xlsx]

(ooxml, embedded labels, table is abc);

Directory;

LOAD Emp,

     SSO

FROM

[Append Test.xlsx]

(ooxml, embedded labels, table is [123]);

Directory;

LOAD Emp,

     SSO

FROM

[Append Test.xlsx]

(ooxml, embedded labels, table is xyz);

[giakoum]

data:

LOAD Emp,

     SSO

FROM

(ooxml, embedded labels, table is [abc]);

data:

LOAD Emp,

     SSO

FROM

(ooxml, embedded labels, table is [xyz]);

data:

LOAD Emp,

     SSO

FROM

(ooxml, embedded labels, table is [123]);

[giakoum]

or more elegant :

for Each vSheet in 'abc','xyz','123'

data:

LOAD Emp,

     SSO

FROM

(ooxml, embedded labels, table is [$(vSheet)]);

NEXT

[Anonymous]

thanks for the prompt reply guys,

a small concern, this was just an example, I have 100 tabs in reality, so will I have to load 100 tables one below the other? or do we have a more smarter solution ?

[giakoum]

you have the solution there. You just need to list the tabs in the for each clause

[awhitfield]

LOAD Emp,
SSO
FROM

(ooxml, embedded labels, table is [abc]);

LOAD Emp,
SSO
FROM

(ooxml, embedded labels, table is [xyz]);

LOAD Emp,
SSO
FROM

(ooxml, embedded labels, table is [123]);

Regards Andy

[giakoum]

one other solution would be to keep the tab names in a separate excel and read them from there

[giakoum]

and this looks like the perfect solution

Loading from multiple Excel files and multiple sheets

[Anonymous]

thanks @ioannis giakoumakis

appreciate your help, whenever you have time, please share this solution "one other solution would be to keep the tab names in a separate excel and read them from there"

just to enhance my knowledge.

thanks again