Appending 3 files bring headers 3 times

[GulianiG]

I have 2 solutions to remove repeating headers from this combined data table

Ee ID	Ee Name	Ee Status
101	ABC	aa
102	DEF	bb
Ee ID	Ee Name	Ee Status
103	dghs	aa
104	sfgh	bb
Ee ID	Ee Name	Ee Status
105	AgfBC	aa
106	DgtEF	bb

Option 1: To promote 1st row as headers and use Does Not Contain Filter after

Option 2: Remove Duplicate Row from entire table

This option works too because no 2 rows are duplicate in the dataset except the repeating headers

Please suggest
1) Which one is more efficient- I have 30 tables with 6000 rows each to append
2) If there is a technique in combining multiple files from SharePoint folder that can avoid bringing duplicate headers

[GulianiG]

@foodd AND @Greg_Deckler Thank you both
We will be moving sources to SQL soon, so query folding via filter advised would help

[Greg_Deckler · Accepted solution]

@GulianiG Well, I would generally say whichever one supports query folding. However, if it is a SharePoint Folder, I do not believe that supports query folding. For the sake of future proofing, I would probably go with Option 1 as it seems like it would be less seceptible to future problems. Also, if query folding were in play, a simple filter would almost certainly fold.

[foodd]

Yes, fully agree, Option 1, and perserve folding with a filter.