Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Merge xlsx files and filter empty files.

Hi everyone!   I have a query than combine xlsx from a folder of sharepoint online. The files arrives automatically.   Files usually have several columns with data. But in some cases arrives file...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I find a solution. When I filter the files, I select those that have more than 2 columns.

     

    #"Filtered rows" = Table.SelectRows(Source, each [Folder Path] = "https://xxxx.sharepoint.com/teams/xxxx/xxxx/" and Table.ColumnCount(Excel.Workbook([Content], null, true){[Item = "Sheet_name", Kind = "Sheet"]}[Data])>2)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I find a solution. When I filter the files, I select those that have more than 2 columns.

 

#"Filtered rows" = Table.SelectRows(Source, each [Folder Path] = "https://xxxx.sharepoint.com/teams/xxxx/xxxx/" and Table.ColumnCount(Excel.Workbook([Content], null, true){[Item = "Sheet_name", Kind = "Sheet"]}[Data])>2)