Forum Discussion
Helper IIAppending 3 files bring headers 3 times
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 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.
3 Replies
GulianiGfoodd AND Greg_Deckler Thank you both
We will be moving sources to SQL soon, so query folding via filter advised would help- Greg_Deckler
Community Champion
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.
