My source data is an Excel File in where I read the range of the whole sheet and save it in a data table. Sample as below:
From the table above, I will filter it by column “Address” and I want to open up a column beside it to write a value that I want to.
Let’s say I filter by (Address “Contains” fine), then the next column it should’ve written “Fine”. Output as below.
I will do the filtering by Filter Data Table activity. So whatever under that table I want to write cell in the next column based on my Filter Condition.
How do I go about on this?