Custom Output file name issue - updates tab not file

To return data before the dynamic input tool use the append field tool

Ideally, you could send the workflow out for analysis.
the csv may have to change the output to UTF-8 .
without real workflow it is difficult;

All comments

To return data before the dynamic input tool use the append field tool

Thank you! That worked.

When I tried two output files an xlsx and a csv. Both generate with different errors.

CSV: File opens fine but conversion errors. I cannot post contents of error so I put "value here". One thing I noticed is that 5 out of 6 had a hypen in hte field. The other had the TM (trademark symbol). Error: Output Data - The output code page couldnt't fully convert the value in the field, "value here"

XLSX: File opening but given the error below (consistently)

Error: We found a problem with some content in 'Alteryx WF Output of NamedReport - YYYY-MM-DD.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

Both outputs are part of the same flow, just added two outputs in different formats to test why the xlsx consistently fails.

Any ideas are appreciated.

Ideally, you could send the workflow out for analysis.
the csv may have to change the output to UTF-8 .
without real workflow it is difficult;

@geraldo

I was using a custom value for that and added the path. When I switch to full path, I get the following output data error

"unable to Open archive for zipping: \MyStuff\Alteryx\Test\Report_Name - 2023-05-10.xlsx. Cannot open file \MyStuff\Alteryx\Test\Report_Name - 2023-05-10.xlsx. The system cannot find the path specified. (3)

I check the FilePath attribute value that was read in through the append to the dynamic input tool and it reflects the name of the file and the |||SheetName. If I parse |||SheetName out indicates I need a sheet name. I am not trying to create a zipped file just a regular .xslx. Again sorry I cannot provide more detail and thanks again.

@geraldo One other observation is that it loops through and creates all files in that directory, not just the one that I selected with Sample tool to load into the Dynamic input too.