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
Solved! Go to Solution.
Hi,
Can you please elaborate your requirements.
Thanks
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.