How to Filter Values of a certain Column, When the Column Name is on the Second Row?

Help Studio
, ,
1

Hi team,

We have a master table that we need data to be processed depending on the ‘In App (Y/N)’ Column. The data is processed only when the value of ‘In App (Y/N)’ Column is Y. And the actual column name (In App (Y/N) is on the second row. How can we do the filter in such a case?

image - 2023-05-17T112032.164
image - 2023-05-17T112032.164980×245 54.6 KB

Thanks a lot for your help.

2

You should set your Read Range activity to start at row 2 and make sure the headers box is checked. Then “In App (Y/N)” will be the column name, not data in a row.

3

@postwick Thanks a lot.
That’s worked!

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.