OTP-category indicator flag

OTP-category indicator flag

Bank Otkritie is building risk scoring by the operation type — payments and regular transfers need different limits and anti-fraud logic. Analytics prepares an indicator to split these streams in the dashboard. Attach an indicator to each row: 1 when category contains payment, and 2 when category contains transfer but does not contain acc. Drop every other row — they don't belong in the dashboard feed. Check the conditions in order: payment wins — a row whose category contains both payment and transfer gets 1.

Any row order

Bank Otkritie

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid