Forum Discussion

ripstaur's avatar
ripstaur
Icon for Helper III rankHelper III
4 years ago
Solved

Can I delete superheaders when combining files in a SharePoint Folder?

I have some excel files that are posted on a sharepoint folder every morning. Each one contains information about product shipments. Each file tracks a particular product. So maybe some units of prod...
  • ripstaur's avatar
    4 years ago

    I got it to work! It turned out that PQ added its own promote headers step, followed by a type change step. Maybe that's because the files I have to work with have a blank row at the top, then the super-header, then the headers. In any case, that change type step is looking for the text in the superheader as it tries to emulate the code in the example file going forward. I eliminated that change type step, added another promote headers step, and it worked like a champ!