Feb 17, 2021 · Hi @NRD - If you want to combine all txt files while also maintaining their import specifications, you may want to read them as text files without delimiters and output back as txt without delimiters. This is how you will read all records from all files in one column and preserve your import specifications.

Oct 10, 2021 · To input multiple files, use the wild card syntax in the path, i.e. "c:\temp\*.csv." This will attempt to load all the files. I say attempt because the schema (column name, Type and order) of the files have to be the same to input all the files successfully.

Mar 8, 2024 · There are 4 different ways to combine files that will be dictated by your use case. You can wild card import files for quick consolidations, manually append with a Union tool or use a Dynamic Input or Batch Macro depending on the file format.

Oct 22, 2019 · Learn how to input multiple files at once in Alteryx using a single input tool or with a dynamic input tool paired with a directory tool!

Struggling to combine all your data files into one for analysis in Alteryx? This video will show you effective methods.

When we have several files to import such as monthly sales data into Alteryx, it can be (is definitely) a pain to import each file one by one.

Dec 6, 2024 · You could use a Select Tool and type in new names OR you could do a few transformations and use the Dynamic Rename Tool to merge the rows dynamically, so you are prepared when 2017 rolls around the corner and they start adding new columns to your file!

Apr 22, 2017 · All you need to do is to extract the file names with the directory tool and then use a dynamic input tool to import the files. The directory tool can be configured to return all files in a folder or only those with a specific file extension.

Apr 14, 2020 · I have four sets of data files in Excel (see attached for simplified version) and want to combine them into one file. I used Union to bring them together and then used the common field - Description to Summarize the data in order to get the following output.

Dec 3, 2021 · You have to input the file twice, once for each sheet. For the 2nd sheet make sure to click on the option that the first row contains Data. Then you can use the Union tool --> Auto Config by position --> Set a specific order (Check). See image links below. First Row Contains Data. Union Tool Configuration. Sheet 1 Example Input. Sheet 2 Example ...