I had address using get text activity and i want to add that text in address column based on item
Use For each row in Data Tabel
Use assign activity
Currentrow(“address”) = Get text Output variable
If you want to add the address based on item value and on the row where item required is there,
First use the lookup datatable activity and find the row position of item value and update the address using
index_row is output from the lookup datatable activity.
your steps could be as follows below!
read range the excel
for each row in readDt
Get text or Get attribute to get the desired address value you need the changing address need to wildcard the attribute that contains adresss
CurrentRow(“address”) = GettextoutVar
Outside the body of the loop
use Write range With same path and sheet and datatable!
i want to write the address based on the item row
follow the approach which i had wrote in my thread
So you are looking something like this?
Search for specific value in the item column and write the address there?
If yes you can follow these steps
- Use lookup range give your item value and store in variable there it will get you the address of the item value
- Write Cell in the particular cell by giving the cell value semi dynamic.
For example Lookup range is returning as “B2”
In the cell range you need to put “C”+System.Text.RegularExpression.Regex.Match(“LookUpRangeVariable”,"\d+").Tostring
thanks for reply
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.