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