Hello everyone,
This is my second post and I am really happy to be part of this community, I am enjoying a lot the learning of UI path. I do need some expert 's help now though.
On the csv attached, there is a list of referral numbers from row 1 to 60 all in column 1.
I would like to use the for each row activity( or any other better method),to take the content of all cells of column 1, one by one ( first one being A1 then A2 until A60), find that content on a website and when found on the website click on it.There will operation in between clicks that is working for me currently. I would like to iterates the clicks and the operation that each clicks has.
Here are both files, let me know if you have any questions.
Thank you in advance.
Boyses testforeachrow.xaml (2.1 KB)
Edit: I cannot attach the csv file unfortunately but this is what the content looks like for that column, a number followed by a letter.
Use the Get Row Item activity inside the For Each Loop take the value form ‘Get Row Item’ by setting it’s properties to Column index as ‘1’. It will give you the Cell value of your whole column. Take that value and do what you want.
@boyses if you want to iterate each row from A1 to A60 I would recommend you to use for each row where you can iterate each row and inside the body you can use that whatever you want.
Hello @Michael_Udhaya,
Thank you very much for answering, I will be trying your method and let you know how it works.
Also what would I need to put in the row input? Do I need to create a string variable for the entire column and put as row?
Just for learning purposes, how would you make the tablerow selector dynamic?
Thank you again,
Boyses
Hello @venkatmalla6
Thank you for answering, I have been trying to use this loop for this project for a while now and it either does not loop or just the take A1 or just take A60. I want to make sure AI understand fully this concept and if there is another method to get a way around it.
Thank you,
Hello @AkshaySandhu,
Thank you very much for answering,just to make sure I understand your answer, you would create a list variable and a string variable to store all info of the first column and use assign activity with List of String ListWords = (From x in dt.Rows select colx = x(“ColumnName”).ToString).ToList ?
Then create the for each str in listword, then click on the first value of the str? what is the next used for?
Thank you
Click Text value as strRowValue
Or use Selector aaname=strRowValue
Navigate to common page.
It will click that founded text until all row values
Iterate.
Use Element Exist to find the file is on the web page. If found then proceed, else iterate next loop.
Or|and Put the ‘Click Text’ into the Try Catch block so you can skip the process.
Thank you very much for your answer again @Michael_Udhaya.
However I do get the error that strrowvalue of value string cannot be converted to system.data.datarow.
When I fix the variable it tells me it cannot converted system data.data row to string… what did I do wrong?
Thank you
@Michael_Udhaya oh my bad, then can you explain to me the row item because now i’m just confused what it is please, what would I need to put on there as it is the only error I have left I think.
Thank you,
@Michael_Udhaya I am sorry but I do not understand what is the data row object is and it the get row activity is not being used in the video, do you have an example for what you would put on there so I understand please? is it a variable, if yes what type?
Thank you,
You have your Datatable variable (dtExcelData).
Put for each row activity. It will came with default variable row nearly Foreach label. It was the dataRow type. Buy we don’t want it now. Next ‘in’ label put your Datatable variable dtExcelData
In the ‘body’ sequence put the Get row item activity. In the text box type row(it was thedataRow).
If your Datatable have headers then you can pass the value in ‘Column Name’ Property. Else pass the index of your column (in your case only one column so you simply type 1) in ‘Column Index’.
In the Output property section put that variable name ‘strRowValue’ (as Generic Value) in ‘Value’ box.
Also look into this video(watch be careful after 11 minutes. It was your question).
Oh okay I was overthinking it way too hard… Thank you very much for your help @Michael_Udhaya I really appreciate it. I do get this error though when I have the whole for each row completed…
Thank you very much for answering @kommijeevan
that is the workflow I have running now, theonly difference is I have csv fille… do I need the read range activity and convert my file first to not get any errors? be low is what I have
This error usefully occurred when your data has Blank. In your screen shot, You mentioned in the Column Index as 1. If you have only one column in your Datatable, then the index should be 0.
@Michael_Udhaya Oh I should have spotted that too… But after correcting that number I get the same error, any other possible cause of that errors?
Thank you
ashokkarale
Yoichi
Anil_G
sudster
Kismet_Tosun
anand.t
k.sakaguchi0804
SorenB
Akash_Javalekar1
Sisay_Dinku