I have an excel sheet, from where i have to read column D and find which row contains a particular keyword,“Shilpa” and find the value of column C of that particular row .
Can any one suggest an idea
I have an excel sheet, from where i have to read column D and find which row contains a particular keyword,“Shilpa” and find the value of column C of that particular row .
Can any one suggest an idea
give a try to setup the flow as following:
Sorry its a csv file
Can you let me know the approach
Use Read CSV activity->Output to a datatable
Remaining process is same
Hope this helps you
Thanks
i tried and got the values of filter data table but how do i store all values in a array or string and use it one-by-one?
The output of filter datatable activity is datatable
It contains the row which had keyword “Shilpa”
If it contains one row then use the followingto retrive the Column C value
datatable_variable.Rows(0)(2).ToString
Regards
Nived N
Happy Automation
I tried to use filter data table and got the output of required numbers , now, how can i store them into a variable and fetch values 1 by 1?
@Shilapshree_Mohanty Can you please explain your requirement in a bit more detail, You can provide us with the below details, so that we could suggest a better approach or a solution.