SharePoint.Contents unable to combine current folder and sub folder files

[StrPod]

When I navigate to a folder using the navigation step, I am unable to combine files in the content column because sub folders are showing as "table" instead of "binary" unless I drill down to a specific folder that does not have a sub folder.  Does anybody know a work around? To convert the table row to a binary so that I can combine all files. I am trying to move away from SharePoint.files as it's cumbersome and increases refresh time.

 

[lbendlin]

Filter out the rows where Extension is null.

What made you choose SharePoint.Contents over SharePoint.Files ?

[StrPod]

I am trying to consolidate all files in the parent folder and all files in sub folders. So filtering out is not what I want.

I heard .content speeds up consolidation, and I want to try it out since .files is taking 30 ish mins to refresh my large dataset atm. 

[lbendlin]

.Contents does not give you the full inventory - you need to do the navigation yourself.

.Files usually works.  What types of files are you processing?

[StrPod]

.xlsx

This is the folder structure

x/ (Parent folder)
├── file1.xlsx
├── file2.xlsx
├── file3.xlsx
│
└── historical/ (Subfolder of x)
    ├── 2019/ (Subfolder of historical)
    │   ├── January/ (Subfolder of 2019)
    │   │   ├── file.xlsx
    │   │   └── ...
    │   ├── February/ (Subfolder of 2019)
    │   │   ├── file.xlsx
    │   │   └── ...
    │   ├── ...
    │   └── December/ (Subfolder of 2019)
    │       ├── file.xlsx
    │       └── ...
    ├── 2020/ (Subfolder of historical)
    │   ├── January/ (Subfolder of 2020)
    │   │   ├── file.xlsx
    │   │   └── ...
    │   ├── February/ (Subfolder of 2020)
    │   │   ├── file.xlsx
    │   │   └── ...
    │   ├── ...
    │   └── December/ (Subfolder of 2020)
    │       ├── file.xlsx
    │       └── ...
    ├── 2021/ (Subfolder of historical)
    │   ├── January/ (Subfolder of 2021)
    │   │   ├── file.xlsx
    │   │   └── ...
    │   ├── February/ (Subfolder of 2021)
    │   │   ├── file.xlsx
    │   │   └── ...
    │   ├── ...
    │   └── December/ (Subfolder of 2021)
    │       ├── file.xlsx
    │       └── ...

etc...

if I am in parent folder its files show as binary but historical shows as table and I can't combine like the image shown in OP. if I go in historical everything shows as table but I am able to combine without navigating to the specific sub folders (years and months). So my only two options are either combine the files in the parent folder, or all the files in the historical folder.

[lbendlin]

Nothing wrong with running two separate queries and then appending them.