Hi team,
I have one excel with few columns and few rows of data
For example I have 10 columns and 8 rows of data .
That is my input file so data is available in Excel i need to extract the details in web application and added to same excel with new columns.
Like I have account number, Invoice number and Date Columns with 10 rows data.
Now I am read the file if data is available I am login to application and extract the required details like tomal amount, pending amount, status and comments.
So I need to add 4 extra above coloms in a input file.
Before adding I need to if account number is available in which column based on the column I have add the respective extracted data in above new colomns in Reframewprk without queues.
I will tell u approach.
You can store data extracted in a DT table say it DT2. And the original input data also in DT, let us call it DT1. Now create a new DT with all the fields call it DTFULL.
Now foreach row inDT2, get Account number, now again inside that add another foreach row for DT1, and check if Account number in DT1, is same as Account number from DT2, if yes, now add all field values in the DTFULL…This will repeat each row from DT2, and finally you will get all rows in DTFULL, export in excel or use it as required.
But I have issue like the input file is my main template so based in the main template data i have to extract and based on account number index I need to add the extracted data in same row.
Is that possible to add the latest data in main template based on account number index .
Hi. To get row number of matching Account number value use Lookup Datatable activity. With RE framework, (transaction number-1) can also be used as row index, if the transaction type is datarow.