TXT to EXCEL and Merge data

[DWTMK]

I Try to transfer TXT to EXCEL Several TXT Files and make data like image below

what activity can I use??

[Nithin_P (Nithin Prabhu)]

Hi @DWTMK,

Welcome to the Community !

1. Read CSV Activity (Comma Seperated) , now the input data will be in a datatable.
2. Add 2 coulmns for Date & Time, when adding set default value to current date and time respectively.

Regards,
Nithin

[xuanhung (Hưng Nguyễn)]

Try this.