topic Re: How to push fields defined in the business rule expression to output or monitoring report. in SAS Data Management

How to push fields defined in the business rule expression to output or monitoring report.

Che — Tue, 14 Jan 2020 16:39:07 GMT

Hello,

I have created a new business rule to identify certain patterns in the address line1 and set up task to run that business rule in Data Job.

My expression looks like this:

string COMMENT
if instr(`VALUE_CHECK`,'ATTN') != 0 or instr(`VALUE_CHECK`,'C/O') != 0 or instr(`VALUE_CHECK`,'%') != 0 then
begin
COMMENT='ADDRESSE FOUND IN ADDRESS LINE1'
return true
end
else
return false

When I run run task using Data Monitoring node in DataFlux data job, it doesn't allow me to send COMMENT field defined above to output or monitoring report.

Question: Is it possible to push fields defined in expression section of business rule to output/monitoring report?

Best regards,

Chetan

Re: How to push fields defined in the business rule expression to output or monitoring report.

VincentRejany — Wed, 15 Jan 2020 22:50:45 GMT

Well the answer to your question is "Yes". However the expression cannot create fields in data monitoring, they have to exist before. Therefore the solution is to create a field "COMMENT" and to use it in your rule. When calling the task you will map it with an empty dummy field.

Although, it is probably redundant to have this field as your rule will only trigger records that match your condition ... therefore all return rows will contain an ADDRESSE IN ADDRESS LINE1 ... You can use the different attributes of the rule for storing this comment and reuse it in the output of Data Monitoring.

Hope that helps