Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Error processing excel files dynamically

anbugans
8 - Asteroid

Hi

 

I am facing below error while reading (input) multiple excel files (.xlsx) using dynamic input option.

 

Dynamic Input (4) The file "\\shareddata\Revolution\Liquidation templates\Europe\Testing\NEW_Liquidation_Template_Golf.xlsx|Equipment" has a different number of fields than the 1st file in the set and will be skipped.

 

Job were running fine when run the jobs separately ( Without dynamic input option) and don't see any issue in sheets.

 

Attached screen shot for reference. Please do the needful

12 REPLIES 12
Begnuser123
8 - Asteroid

Hi @Joe_Mako ,

 

I am getting the error, The document was created by a more recent version of the application and cannot be read.Please advise.

Joe_Mako
12 - Quasar

@Begnuser123 I recommend updating to the latest version of Alteryx.

 

If that cannot be done, please see https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Adjusting-Alteryx-Files-for-Different-Versio... for a method that may work, your mileage may vary.

 

Or you could modify the macro yourself, using the image as a guide, add the two tools, and configure as shown. If you have never used Interface tools before, you can check out https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Creating%2...

 

If you need help, please message me and we can setup a screen share to walk though the steps.

Begnuser123
8 - Asteroid

Hi @Joe_Mako. The version I am using is 11.0.3. Could you please repaste the image of your workflow. I will give it a try. Thanks for the offer. I will reach out in case it does not work out.

Labels