How to use data from pivot table

[raju_alakuntla]

Hi,

We have some data in an excel in pivot table format, We want to check the data with excel’s data to web portals data and need to turn on the radio button for each item in the excel.

Excel file data:

Web portal:

Regards,

[Shubham_Kinge]

@raju_alakuntla

We want to check the

Hello @raju_alakuntla
First while creating the pivote choose the tabular form of the activity. then try to read it from A2.
If your table is directly comming then open it with excel scope and the hotkeys like Alt+JYPT

Hope this solve your issue.

[raju_alakuntla]

No. It should be Pivot table only, because we need to check for the each terminal under each DTAP. If I read this excel sheet using read range activity but I don’t know how to click on the first Dtap and loop through for corresponding termninals.

Regards,