stage variable: Check for string and output row

[rajeevm]

Hi

I have a requirement that to check for the string in a column and return that entire row to the output . Suppose I have 'true' in the column then return that else return the row which has 'false' . I am trying to do this in stage variable not sure the approach is correct .

I have total 6 columns

Please help me out how to write it as a stage variable I really appreciate your help

Thanks
Raj

[chulett]

We'll need a better explanation than that to really be able to help, I'm afraid. Can you post some actual examples of the strings you need to search? For example, I'm unclear if what you are looking for is a total match or a substring match. Also unclear if you need to check all six at once and return one of the six... or something else.

[ray.wurlod]

Allow me to re-parse your stated requirement and then offer my "solution".

(If column = 'true' Or column = 'false') Then transfer row to output.

Solution: transfer all rows to output.