Hi,
After using a read range activity, how do you get specific rows based on a criteria?
For example if I read a table and want to get every row that has a “N/A” and store each row count (example: rows A11, A50, A190 have “N/A”) into separate variables.
Or another approach I could think of would be to filter the table within excel for “N/A” and then get the data from there.
After ReadRange, take for each row activity and pass output of ReadRange, then take assign activity and assign row(0). it will gives you the output of all row of 1st column. for displaying the output use LogMssage activity or WriteLine Activity.