I’m want to filter a condition for a column which is dynamic.
The bot runs weekly so when the excel is exported new latest column is added to the sheet.
1st week run:
week 1 , week 2, week 3
Need to read week 3’s data.
2nd week run:
Week 1 , week 2 , week 3,week 4
Need to read week 4’s data
And so on.
I hope I’ve explained it well enough.
Kindly please help.
You can get the week of the month
Check below for your reference
Hope this will help you
First read the excel file using READ RANGE activity and get the output as dt
Now use a assign activity like this to know the number of columns you have
int_columncount = dt.Columns.Count
Now use a for each row activity and pass dt as input and inside the loop use a assign activity like this to read the last newly added column
str_value = CurrentRow(int_columncount-1).ToString