Hi all,
4 similar files are selected from a folder , sorted by creation time and 1st file is selected.( using dynamic input tool )
I created a workflow which gives a output column of a file as given below for the first file.
OUTPUT for 1st file :
DATE -> ( header )
21/10/2021
0
12
23
31234
Now how to make the same worflow run for other 3 files batch after batch and update values in a table?
expecting output:
DATE | DATE | DATE | DATE |
21/10/2021 | 22/10/2021 | 23/10/2021 | 24/10/2021 |
1230 | 1230 | 1231 | 12342 |
123 | 332123 | 123 | 1231 |
12312 | 12312 | 12432 | 123123 |
Solved! Go to Solution.
Can anyone help! Im stuck on this.
Please share some sample data for the same,
Hi @Pickaxe
Here's one way you can do it
The Input Data tool uses a wild card pattern to read in all the files in the directory. The two Multirow tools add Rows and Output Column number and the Crosstab gives you the final result.
Note that your output has 4 columns called Data. This isn't valid in a dataset where each column needs a unique name. That's where the column number comes into play. The field names after the Crosstab are actually the unique column numbers, but since the Output Data tools is configured to Skip Field Names, the column numbers aren't written to the output file
Dan
hey dan , can you provide the sample source data for better understanding,
To put in simple words I want to join columns Into a table. Using UNION tool gives Null value , Append tool creates many duplicates. any other solution to stich columns together
Thanks,
Pickaxe
Hi @Pickaxe
The samples are included n the package attached to my first post. When you open it using Alteryx, it expands to the workflow and 4 excel files all in the same directory. Change the path in the input tool to be *.xlsx
Dan