How to set the dates when the field against the date is changing

Help Studio
1

Hi,

In the Excel file we have column “Names including start date and end date” but in the web portal we have divided the excel column names into 2 parts like “Name as Rows and start date and end date as Columns seperately”. Now we want to set the dates against their respective Names in web portal. We need to match the Name first and then dates. If Name is not matched then look for the matching name in the next rows in the web portal.

Here I am sharing screenshots of excel file and webportal.

image
image1546×496 19.1 KB

excel

image
image1112×102 3.13 KB

Regards,

2

@raju_alakuntla

Use get attribute activity on the name cell and get the tablerow property then the tablerow property value can be used to write the remaiining cells

Eg : for get attribute <webctrl tag='TD' tablecol='1' innertext='{{NameVar}}' />

Eg : for set text or type into <webctrl tag='TD' tablerow='{{VarRow}}' tablecol='4' />

These are for illustration original selectors please find from ui explorer but they will be close to this

Cheers

3

not getting the solution.

Regards,

4

@raju_alakuntla

Please elaborate on what youa re not getting…with out those its difficult to pojnt you in right direction

Cheers

5

Input excel file has mainly 3 Columns:
image

The 2nd Column has some names but in the portal these names split into columns and rows.

image
image1585×528 36.9 KB

We need to set the dates which are in the 3rd column in excel,

How can we automate it. Please provide solution.

Regards,

6

@raju_alakuntla

Few pointers here

  1. The data is not exactly matching with the data on web site…that should ideally match…
  2. There is no proper separation between the column name and row name…will the columns names be always Actual date and start date …if yes then we can replace that and try using other part as name…

For the first point better get data exactly matching if not may be we need to go with fuzzy selector and try…

And the approach provided above is still the same on what you need to do…

And that shpuld eb done inside a for each tow in datatable activity where datatble is read from
This excel

For replaceing actual date or start date and get the name use currentrow("ColName").ToString.Replace("Actual Date","").Replace("Start Date","")

And to check if it contains start or actual use currentrow("ColName").ToString.Contains("Actual") this would return true if presnet else false

Hope this helps

Cheers