Forum Discussion

wilson_woon's avatar
wilson_woon
Regular Visitor
9 years ago
Solved

remove duplicate headers after combining multiple files

Hi all,   I have several csv files to be combined together into a single file for editing and analysis. Each csv file has some headers and these headers are the same. As you can imagine, these head...
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    wilson_woon

     

    As the column names are known, you can remove the header rows with Table.RemoveMatchingRows.

    Check

     

    let
    Source = Table.FromRows({{"data1","data2","data3"},{"column1","column2","column3"},{"data1","data2","data3"}},{"column1","column2","column3"}),
    RemoveHeaders = Table.RemoveMatchingRows(Source,{[column1= "column1",column2= "column2",column3= "column3"]})
in
    RemoveHeaders

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago

wilson_woon

 

As the column names are known, you can remove the header rows with Table.RemoveMatchingRows.

Check

 

let
    Source = Table.FromRows({{"data1","data2","data3"},{"column1","column2","column3"},{"data1","data2","data3"}},{"column1","column2","column3"}),
    RemoveHeaders = Table.RemoveMatchingRows(Source,{[column1= "column1",column2= "column2",column3= "column3"]})
in
    RemoveHeaders