This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have small query and unfortunately due to confidential data, I can't post example here.
My data-set is like this:
Column A | Column B | Column C
1 | ABC | Maximum
2 | DEF | NIGHT
3 | LFG | Stupid
So I am input the file and then filtering using "CONTAINS([Column C], "NIGHT")" and doing it for multiple fields. I want to have another Column D showing that this field was filter based on "NIGH" criteria.
Appreciate if you can help or guide me in this. I have already tried to find few examples but unfortunately they were not that clear.
@bpatel - this is something close to what I want but rather than 0 or 1, I want it to show me filter criteria like "Night". Further, I have multiple CONTAINS (almost 100+) so typing for each would be difficult.
the Filter tool has no option to mark filtered records using a comment. I would suggest to use either a Formula tool first Formula calculating Column IIF(CONTAINS([Column C], 'Night'), 'Filtered based on "Night" in Column C', Null())
and then a Filter tool (!IsNull([COLUMN D])
If the content of the column matches exactly, another option is to use a list of items to filter (one column containing "NIGHT", second column 'Filtered based on "Night" in Column C') and to "filter" by a Join tool ("J" anchor will return only the items fulfilling the condition and the comment).