community Alteryx IO Mission Control
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
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 130 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