Help required for joining multiple excel with single sheet and same format

[Eug_teng]

Hi all, I have multiple excel files which have the same format and I would like to join them instead of union. How do I go about doing this besides manual inputting every file and join multiple?

E.g File A

A
1
1
1
1
0
0
0
1
0

E.g File B

B
1
1
0
0
1
1
1
0
1

E.g Output

A	B
1	1
1	1
1	0
1	0
0	1
0	1
0	1
1	0
0	1

All excel files have the same number of rows and I have about 50 of these files. Thank you!

[vizAlter · Accepted solution]

Hi @Eug_teng — Hope this will be helpful:

If this solves your issue please mark the answer "Solved" with a Like, if not let me know!

[grazitti_sapna]

Hi @Eug_teng , this can also be done using multi row formula.

Input tool configuration, replace the path with your path and output file name as field should be set to file name only.

If it helps mark this post as solution.

Thanks.

[Eug_teng]

This works! Thank you!

[vizAlter]

@Eug_teng — Thank you!