Convert to text file

[fairymemay (noona)]

I want to convert excel to text file as below.

Please suggest me about this.

[Pradeep_Shiv]

Hello @fairymemay,

You can try this

• Use Read Range and get output as outDataTable
• Now use Output Datatable Activity and get the the output as outStr
• you can pass outStr Variable to Write Text File Activity and pass the file path.

Cheers
@fairymemay

[fairymemay (noona)]

@Pradeep_Shiv How to set end indicates (net)?

[Pradeep_Shiv]

Do you want to group them by “Net”?

[fairymemay (noona)]

@Pradeep_Shiv I​ want​ copy​ net​ to​ column​ F.(red​ text)​