combining columns into a table from different excels.

[Pickaxe]

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

[Pickaxe]

Can anyone help! Im stuck on this.

[binay2448]

Please share some sample data for the same,

[danilang]

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

[Pickaxe]

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

[danilang · Accepted solution]

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