As per the image I have such columns somewhere 12 and 15 in each item. I am confused that how should I update price and discount in each one of them till the end as there can be 10 location and there can be 15 too and sometimes there can be duplicity of locations too.
Hey,
I am storing it in an excel sheet.
Hi @Sonam_Nath,
You have to first read the data from excel using read range and then you have to fine tune the selector so that it will jump to next column according to index or whatever difference you find in two selectors.
e.g.
for first column <webctrl id= 'Discount1'>
for second column <webctrl id= 'Discount2'>
so here there is a change in id ending value
there you can place a variable and increment the value on each iteration
something like this
<webctrl id= 'Discount{{**index**}}'>
and increment index by one everytime you go through each item
Regards,
Firoz