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

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

Bug

Accepted answers

messi007

@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

All comments

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,

OutputFile_20220201.yxmd

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

@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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703