How to copy the data from text file to new text file based on excel values

Help
1

Hi Team,

I want to copy the text file rows to new text file based on the matching condition(values in excel file),and the new text file should contains header and footer same as summary file(Attached).

Regards,
Rajesh

Summary%20File%20Data
Summary%20File%20Data1353×460 39.5 KB
UnsuccessfulAgents.xlsx (8 KB)

2

Hi @RajeshT

The easiest way would be to first get the data in the text file read to a string and then get it converted to a datatable. You can split the data by the tab or space delimited.

Then, read the other excel sheet to another datatable. Then to find the matching condition, join the two data tables using join data table activity that will give you only the matching records in return.

Once done, write the matching data to the new text file.

Hope it helps

3 Likes
3

Hi @Lahiru.Fernando,
Can you please check the xaml about get the data in the text file read to a string and then get it converted to a datatable..Is it correct way of starting the flow?DatatableConversion.xaml (7.5 KB)

regards,
Rajesh