Question
Infosys
IN
Last activity: 16 Jan 2018 0:44 EST
Did not found GetItem (columnName) method in dataRowProxy1.
Hi ,
I am creating one automation using ForLoop in Excel. Found this sample automation on youtube.I am following every steps mention in that but am unable to find GetItem method(Highlighted in image) for columnName.Can anyone please let me know what is the issue with below automation(Why GetItem method for columnName missing)
Accepted Solution
Pegasystems Inc.
US
GetItem requires a column index. You are already specifying the column index when you are using GetItem to get the column name from the columns collection. Use the same index (from forLoop2) as the input to GetItem from your data row proxy.
Infosys
IN
Hi,
Thanks for reply. Actually What I want to show here is each columnName and its value for each row in message dialog.When looked for GetItem(String) method in Configuration type,not found any(GetItem) method for string value.Only GetItem method is available for (Int32 columnIndex) : Object. Is am missing something while creating this.
Please suggest and correct me if am wrong.
Thanks
Pegasystems Inc.
US
You already have everything you need. You need to use the columnIndex value to get the value and the column name. Just concatenate them for your output.
Infosys
IN
Apologies I didn't get how to concatenate columnIndex value and column name.Its very helpful if you post the same or any sample automation to get the excel cells values using ForLoop.
Thanks
Infosys
IN
Hi Jeff,
Thanks for your valuable support.Finally am able to do that as you suggested to me.Sharing the automation screenshot so that it may help someone in future who will face the same issue.
Thanks