Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Error Opening File - Output Tool

KamenRider
11 - Bolide

Guys,

 

I am having difficulty in figuring out how to fix this error. The excel files are close and yet I am receiving error, "ERROR OPENING FILE.... "

 

My formula tool configuration are.:

 

1. Sheetname - '01-31-2021'

2  Filename - 'Recon Tracker - ' + [Sheetname]

3. Filepath - FileGetDir("......... ) + [Filename] + ".xls |||" + [Filename] 

 

My output file configuration is

 

File Format - .xlsx

Output Option - Overwrite Sheet or Range

Tick the - Take File / Table Name from Field

Field Containing Filename or Part of the File Name - "Filepath (untick - Keep field in the output)

 

I hope you can help me find the solution on this matter as I can't really see what I am missing.

 

Thanks, 

Mar

10 REPLIES 10
KamenRider
11 - Bolide

HI @danilang 

 

The error message is "Error Output Data (255): Error Opening File [File Path and File name]. I've count and you're right, it is 260 characters including space. Is there a possible way to increase the length of characters? or any possible solutions if this is indeed the issue?

 

Looking forward for your reply.

Thanks

Mar

Labels
Top Solution Authors