--SELECT * FROM E_DW_VIEWS.V_DATOS_SECUNDARIOS_SUNAT
--WHERE RANGOVENTAS IS NOT NULL

SELECT NUMDOC,
                MAX(FLG_MERCADO_BPE) FLG_MERCADO_BPE,
				MAX(FLG_RESCATE_MICRO) FLG_RESCATE_MICRO,
				MAX(FLG_RESCATE_BPE) FLG_RESCATE_BPE,
				MAX(FLG_RESCATE_BE) FLG_RESCATE_BE,
				MAX(FLG_BARRIDO_TLV_BPE) FLG_BARRIDO_TLV_BPE,
				MAX(FLG_PROVEEDORES_CORPO) FLG_PROVEEDORES_CORPO

(logica)
UNION 

SELECT LENGTH(NUMDOCUMENTO) = 11 AND NUMDOCUMENTO LIKE '10%' THEN SUBSTRING(NUMDOCUMENTO, 3, 8) ELSE NUMDOCUMENTO END NUMDOC,
                0 FLG_MERCADO_BPE,
				0 FLG_RESCATE_MICRO,
				0 FLG_RESCATE_BPE
				0 FLG_RESCATE_BE,
				1 FLG_BARRIDO_TLV_BPE,   --check
				0 FLG_PROVEEDORES_CORPO
FROM  E_DW_VIEWS.V_FEEDBACK_TELEVENTAS 
WHERE  FEC_LLAMADA >= '2021-01-01'
AND (
    ID_CAMPANIA like '%BPE%' OR  ID_TRATAMIENTO like '%BPE%'  OR TIP_CLIENTE like '%BPE%' 
)
AND PREFIJO_CAMPANA = 'TLV'

UNION

(logica)
GROUP BY NUMDOC