Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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