Splitting a spreadsheet to multiple Excel workbooks and tabs by column names

Question

Hi Team,

I have a spreadsheet which I want to split using column names and save as different workbooks but also different tabs within the workbooks.

PeriodProjectDescriptionFilenameMayXeroxblah blahAJuneBlueblah blahBSepFullerblah blahCJanCanterburyblah blahASepSolarblah blahBSepCanterburyblah blahA

So in the above instance I would want to split Filename into different workbooks and have Project split into tabs within the corresponding workbook.

Hope this makes sense. Happy to provide more information.

BA · Answer

Thanks so much for this, this is the closest to what I am looking for.  I did change the filename to be the project name so it saves as in different files and corresponding tabs.

I am getting an error message though:

Error: Output Data (46): Internal Error: STD Exception in thread: boost::filesystem::status: Access is denied: "[file path of some sort]...."

Not sure how to workaround that.

Nezrin · Answer

Use formula to create a dynamic file path and Specify the column on the output tool

binu_acs · Answer

@BA Sample workflow attached

Multi_Tab_300623.yxmd