Input Data: Inconsistent results from Output File Name as Field

jlefeaux

I have two separate Alteryx workflows.  Each workflow begins with an Input Data tool that reads in an Excel file. Each of these Input tools has 'Output File Name as Field' configured as 'File Name Only'.

In Workflow A, the Input tool returns just the file name.

In Workflow B, the Input tool returns the filename, the .xlsx extension, the 3-pipe sheet delimiter |||, and the sheet name.

Workflow AWorkflow B

 What gives?

There are only minor other differences between the two -- none that I could see causing this behavior

• Workflow A was originally created in 10.6 but has been modified in 11.0.  Workflow B was created in 11.0.
• Workflow A starts data import on line 4 and workflow B starts on line 1.
• Workflow A has 'First Row Contains Data' checked (to stop Alteryx from naming the fields--maybe I don't need this anymore with 11.0; haven't checked)

 Any insight greatly appreciated.  Still fairly new to Alteryx.  Thanks!

SophiaF

@jlefeaux - thanks for the detailed steps so I could reproduce; it looks like the issue is happening when you have a sheet name with a period (.) in it. As Excel does allow files to be named with a period, I expect this is not intended. 

I will have our development team get eyes on this and update the thread.