Append of two columns to form a new column for multiple Text File
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Can you please elaborate your requirements.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
![](/skins/images/33644471E927638F516C93A75ADDEE18/responsive_peak/images/icon_anonymous_message.png)