output file corrupted when i use take file/table name from field option in alteryx

[Suresh]

Hi Experts,

Myself new to alteryx and learning by checking the options on test run. I have a table with 9 columns and in that 1 column got company names and based on that i am trying to split the data into multiple sheets but when i run, its generating the output file with the different sheets based on the company names but file is getting corrupted. Any guidance will be appreciated. 

Note: This table is based on the 2 sources data joined and recon performed and we have a column which got blank cells.

Thanks

[messi007]

@Suresh,

I created a sample workflow that allow to create a file with 3 sheets as I have 3 categories.

Attached the workflow,

Regards,

[Suresh]

Thank you for your time and guidance !

can you please let me know here output is the final output file and + [categ] is the heading of the column which i want to use it for splitting sheets? 

"Output.xlsx|||"+[categ]

[messi007 · Accepted solution]

@Suresh,

- Output.xlsx is the file path (You can add the path like "c:\Aletryx\Test\Output.xlsx")

- [Categ] will be 03 - Entity label

And the option have to be change entire file path

[Suresh]

I am getting error message as 

Error: Output Data (27): The field "\\Folder path" is not contained in the record.

Thanks

Suresh

[apathetichell]

On your last image you didn't toggle from "change file/table name" to "replace entire path" .... Can you also confirm that in the sheet name you are adding there are no "$" or other special characters?

[Suresh]

Thanks for your inputs.. 

after changing also same error and no $ or special characters used in the sheet names only space you might find in it

[Suresh]

Thank you so much for the help! Actually we changed the sheet names without special characters and saved the file path to desktop after renaming which worked for me.. Thank you and have a great day ahead !!

[Suresh]

Please connect once in office to guide on the path change for the output file which we saved in the desktop.. Suresh-Kumar Raichur