ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Community Gallery

Create, download, and share user-built tools and workflows.
Looking for Alteryx built Add-Ons?

Easily shop verified, supported, and secure Partner and Alteryx built Add-Ons on Marketplace.

LEARN MORE
Dynamic Input Allow Different Fields Tool
Tools Uploaded by 17 - Castor on 07-17-2022 Downloaded 147 times
  • Automation
  • Tools
    • Download
    0 Likes
    Post Comment

    Description

    IraWatt_0-1658073508742.png

     

    This Dynamic input Tool unions on column position meaning the schemas do not need to be the same between files. 

    IraWatt_0-1658073405988.png

    Just pass the tool the files location.

     

    If you have any issues please comment below.

     

    Attachments
    Dynamic Input Allow Different Fields.yxi
    Comments
    jboyette
    5 - Atom
    ‎06-02-2023 04:33 PM

    Will this tool output the filename?  I am currently using the standard Input tool, which has an option to output the filenames as a field.  From this, I'm parsing to get a date that is embedded in the filename.  The problem I have with the standard Input is that, when I'm using the * wildcard to input multiple Excel files from the same directory, one of them has a column set to v_Wstring instead of v_string, which throws off the input and doesn't import that file.  

    I thought I could use this tool, but I can't seem to find out if it can output the filenames of the files.

     

    Jason

    0 Likes