Main frame automation

I’m working on a prism application. I’m trying to automate this screen. I need to select any one of the fields based on the data I get from the excel file every time the bot run.

You need to do quite a bit of string manipulation here. First extract the complete text then based on the text you need to select get the row index then move your cursor to that row and then type something to select it.

Hi @sathish_kumar3 ,

I have done this in past, let me share my experience how i achieved it.
Follow below steps:

1 - Extract data from screen scrapping (only select table data excluding headers).
2 - Use GenerateDataTable activity to create the data in the form of rows and column.
3 - Once you have output dt from GenerateDataTable Activity, Do iteration on output dt to match excel value.