Hi,
Within the output tool, I am using the take file/table name from field ouput option to dynamically output my data. I am outputting the data to a range in excel that is already formatted (ie no decimal places in accounting format). The output overrwrites my excel format. I am able to keep the formatting the same when I don't take the file/table name from field and check the 6th option "preserve formatting on overwrite". However, I need to use the take file/table name from field option. Is there a way to preserve formatting with this option?
Thanks.
Are you overwriting the whole path using the range in the path as well?
Yes i am overwriting the path to include the range.
All right, I'll see if I can recreate. If so, it's probably going to be a Support ticket. Definitely shouldn't be happening in my opinion.
I was not able to recreate - I used the checkbox with replace entire file path and it worked.
I have 12 different output tools with a preceding formula tool that tells where to output to my range on Excel. The formula tool is like this: "my file path"+[FileName] (corresponds to tab of excel workbook) + "range" (range differs per each output tool but is the same for all 12 of my tabs.
Right, that's the same thing I did. The field "PATH" in my output tool that I'm changing the entire path with is a dynamically created path/range using a formula tool. Does your formula tool produce the full path/range with quotes around the sheet name/path as in my screenshot's original path? Long shot but you never know.
I think Alteryx doesn't support preserving formatting when using the take file name from field option in output. I found the same question asked a while ago:
Do you know how to add a support ticket for Alteryx to solve this?
Thanks!
To submit a ticket, there's a Support menu item at the top of the menu bar (https://community.alteryx.com/t5/Support/bd-p/SupportPage). Although like I said, I did get this to work without issue (see screenshot above - and here is the formula I used):
PATH:
"C:\Users\mbarone\Desktop\XLSX2.xlsx|||'Sheet1$A1:E10'"
And again, watch those quotes. Sometimes they make a difference. For me, my formula is in double quotes, and the sheetname/range is in single quotes.