Sunday, 2 March 2025

Total counts of Records using Reformat

 let decimal(15) tot_rec_count=0;

/Reformat operation/
out::reformat(in)=
begin
if(next_in_sequence()>0)

begin
tot_rec_count = tot_rec_count + 1 ;
end
out.count::tot_rec_count;

end;

log_event_t log :: final_log_output() =
begin
log.event_type :: “Summary”;
log.event_text :: string_concat("Total No of Records = ", tot_rec_count);
end;

 After reformat Trash the flow. Collect your rec count in Log port.

No comments:

Post a Comment

how to create dml dynamically in Ab-initio

 $[ begin let int i = 0; let string(int) complete_list = "emp_nm,billable,age,designation,location"; let string(int) file_content ...