Disclaimer:
This macro was based on CReW Wildcard Input Macro from CReW Macros set and is in no way related with or quality checked by CReW team.
The CReW Macro pack credit belongs to its original developers.
Credits for original CReW Wildcard Input Macro:
Macro Author: Ned Harding
Macro Layout and Annotation: Adam Riley
While this enhanced version of the Wildcard Input Macro named CSV Friendly Multi-Input was not built by CReW team, the macro file structure was built in a way similar to CReW Macro tools for easy integration with existing CReW Macros.
The network path bug (posted by @haraldharders) is also fixed in this version of the macro. Please write in the comments below if you encounter any unexpected behavior.
Recommended installation path:
1. Download and install CReW Macros following the instructions on this page.
2. Download this macro set (YXZP file).
3. After importing the YXZP package in a location you choose, move its contents into the Macros folder of the CReW Macros installation directory where other macros (.yxmc and .yxmcbatch files) are also found.
Differences from original version:
1. Still supports wildcard data processing with a focus on configuration of the text files (only CSV and TXT extensions are supported for text files).
2. Automatically detects the delimiter character (should work successfully for 95% of the text files containing only Latin alphabet characters) for each individual file with CSV or TXT extension (supporting macro for this feature [CReW_AutoDelimiterDetection.yxmcbatch] was additionally built ("CReW_" prefix was added only for file sorting convenience) and has no documentation, please open the supporting macro to see additional notes).
3. Outputs file name as field by default.
4. Adds a AYX_CFMI_RecordID field that resets for each FileName.
5. Allows users to specify the Ignore Delimiters in Quotes setting (Quotes by default, applies to all text files).
6. Allows users to specify a code page (Unicode UTF-8 by default, applies to all text files).
7. Allows users to optionally specify a Dynamic Rename formula which is individually applied to all input files.
Update v2.5 (2024-06-28): The batch macro that automatically detects the delimiter was updated to account for delimiter mismatch, especially when space characters equal or surpass the actual delimiter character while still allowing the space character to be properly detected as a delimiter, based on this link provided in this discussion by @apathetichell.
Update v2.7 (2024-07-01): Provided an option to use the previous RegEx pattern for delimiter detection, named as Prioritize space over other delimiters.
Update v2.9 (2025-05-09): Added the functionality to read in the text files without headers (currently not available as an individual setting).
Update v3.0 (2025-07-03): Major update, provides several new options separately for Non-Excel and Excel files. For this reason, it is now also necessary to specify which formats are being read in by choosing between Hybrid mode and Single format mode (only Excel files or only non-Excel files).
Update v4.1 (2025-07-12): Another update now allowing user to apply Multi-Field Formula, Custom Filter and Dynamic Select to the input data. File mode specification is no longer necessary.
Update v4.2 (2025-08-18): New update incorporating the use of the new Data Cleanse Pro tool introduced in Alteryx Designer 2025.1 to remove letter and number characters from any language, made possible by the Unicode ICU support in the tool. Also includes fixes for the final Dynamic Select formula generation. All macros in the package now use AMP Engine with Engine Compatibility Mode enabled.
Update v5.0 (2025-08-20): Sorting logic refinement and logo update to align with NeoInfiniTech branding.
Update v5.1 (2025-08-21): Added backwards compatibility to work with Alteryx Designer versions 2023.x and above.
Update v5.2 (2025-08-22): Added custom filter functionality for Excel files, making it possible to fine tune the file and sheet selection.
Update v5.3 (2025-09-07): Added the capability to force a delimiter character and assign a name to the read in data for use with control containers and log parsing.
Update v5.4 (2025-09-15): Added alternative delimiter detection options to handle rare cases encountered while parsing text files.
Update v5.5 (2025-09-19): Specifying \0 (none) or the [Delimiter] column itself as the delimiter in the "Specify a formula" mode (when the "Force specific delimiter" option in the "Non-Excel Specific Settings" tab is selected) no longer results in an error message.
Additional release notes can be found in the Comment tool present in the main macro CReW_CSVSupportedMultiInput.yxmc.
Important Note: It is not recommended to directly replace the old macros in your workflows with the new one as all the parameters are now named and it might break the old workflows. You can instead place this macro separately for each input, configure the new macro based on the old one and then delete the old version.
The most recent version of this macro (5.5), which is the only version available for download, is only compatible with Alteryx Designer 2023.1 and above.
For the sake of convenience and preservation, a copy of CReW Macros will be downloaded with the name CReW_Macros.zip when you click the Download button.
