Append of two columns to form a new column for multiple Text File

[rohit782192]

How can we join Date and a column from more than 200+ Text file from a directory to form a new column
All Date and column are in a Different File.txt

I am successful for one file but for other it is not working as Expected
Eg
Date             Name
2023-04-22  JOHN
2023-03-22  VICKY
2023-02-11  KICK

[TheUdbhav]

Hi,
Can you please elaborate your requirements.
Thanks 

[Yoshiro_Fujimori · Accepted solution]

Hi @rohit782192 ,

Do you mean like this?

Input

.\InputFolder\File1.txt

Date Name
2023-04-22 JOHN
2023-03-22 VICKY
2023-02-11 KICK

.\InputFolder\File2.txt

Date Name
2023-04-30 MIKE
2023-03-11 JANE
2023-02-25 PAUL

Input Data Tool configuration

Output

I don't fully understand what you mean by "to form a new column".

So I just appended the records in the directory.

If I overlook anything, please point it out.