Data table operations, advance

Hi All,

I am stuck in a data table operation.
Here is the problem:
Input in form of Excel File(Logs from orchestrator) in which I need to search a string in a particular Column( “Column C” only)
After the search I need to copy the cell in which result is found along with the next 2 columns in which the result is found.

I need to do this operation for every single column I found with the string search.
Kindly help

thanks,
Mohit

@mohitkumar.gupta

Check as below to match the string
Tutorial : How to check a string is present in Excel Sheet || Part - 1
Tutorial : Check value exists in Excel Sheet using UiPath (Part-3) | Without using ForEach Loop/FilterDatatable

Copy the value to datatable
https://forum.uipath.com/t/rpa-datatable-get-previous-row-column-value-set-to-current-row-column-value/256199/2

Hope this helps you

Thanks

I got the row index where String was present,
Now I am able to copy the current row by using add data row to new dt,
how can I add the row of current row+1 and current row+2 to the new dt.

thanks

Hi @mohitkumar.gupta,

just add two more add data rows along with the previous one and you can also increase the row index accordingly.

Thanks,
Shikhar