How to convert text file to Excel file and copying 1st and last column of excel

Help
, ,
1

Hi Team,

How to convert text file to Excel file and copying 1st and last column of excel.AGENT_TEXT to EXCEL.txt (1.3 KB)

2

Hi @RajeshT

Use Build Datatable Activity given the columns

do read text file and do split the values

Thanks
Ashwin S

3

Hi @AshwinS2 ,

I have tried using Build Data table ,but because of unstructured data I could not able to convert the data in to excel .
Please look in to attached xaml.TextFile.xaml (85.2 KB)