how to get all headers of columns with specific value in specific cell?
I have a problem with filtration of datatable. I’ve got file “config” with all information who sends an email to whom.
CONFIG.xlsx (13.6 KB)
My workflow look like that:
- User write his email adress (by “InputDialog”)
- Robot read range from file “CONFIG.xlsx” and put it to DT_1
- For each row in DT_1 -> if -> row(“email”).ToString=user_email
and what now?
I want to get all headers of columns with cells contains “1” in this specific row
How to filtrate it next?