Qlik Replicate: source table column with special char based "Record Selection Condition" filter condition expression

[wei_guo]

How do you write a "Record Selection Condition" filter condition expression when the source table column includes special characters, such as ab#, a$b, ab@c?

1. Enable task special by: Task Setting → Transformations and Filters →  Change to Task Policy and check Support special characters in column names used in expressions 
2. In the Designer: → Selected Tables → select the table that needs the filter → Table Settings → Filter → Record Selection Condition

Example (comparing with BI_XX) : 

($AR_H_OPERATION != 'UPDATE')
OR ("ab#"!= "BI__ab#")
OR ("a$b" != "BI__a$b")
OR ("ab@c"!= "BI__ab@c")

Environment

• Qlik Replicate