Custom Output file name issue - updates tab not file

[kimc745]

My previous scenario has evolved.  The ask is that the input file name is part of the output file name with some sort of custom value (standardized) indicating it is output.

For example:

Input file:  ReportABC-2023-05-15

Output file:  Alteryx WF Output of ReportABC-2023-05-15

I have built the custom string for Output_File_Name by "Alteryx WF Output of " + [FileName] and in the formula tool it is working in the preview.  However, when I run it, the name changes only on the tab in the file and not the output file.

I have Take File/Table Name From Field checked. 

and dropdown to Output_File_Name 

Keep Field in Output unchecked as I don't want it to be part of the dataset.

What am I missing?  I tried to do FullPath but once my data is read into the Dynamic Input tool, I no longer have access to the FullPath attribute.

[geraldo · Accepted solution]

@kimc745 

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

[kimc745]

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.

[geraldo · Accepted solution]

@kimc745 

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;

[kimc745]

@geraldo UTF-8 Fixed the CSV conversion errors - thank you so much!  If i cannot get the xlsx to work, at least I can provide CSV in interim.

Apologies, cannot send workflow as it is not a sample but something with confidential data.  I understand that adds difficulty in assistance.

Any ideas why the .xlsx would keep throwing a corrupted error when attempting to open the .xlsx version?  Saves w/out issue.

[geraldo]

@kimc745 

Your excel configuration should look like this:

Switch to:

[kimc745]

@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:  D:\MyStuff\Alteryx\Test\Report_Name - 2023-05-10.xlsx.  Cannot open file D:\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.

[kimc745]

@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.  

[kimc745]

@geraldo 

Here is the problem I was having and found a solution (the error when opening in excel) it was the ' and ' around tab names.