Migrating AbInitio Lookup_count () functionality into talend
Hi , i am working in AbInitio to Talend migration PoC, i am finding dificulty to Migrating AbInitio Lookup_count() functionality to talend . Please help me to do this in talend.
let integer(8) parent_count=lookup_count("Lookup - DSMT_MAN_SEG_HIER- {CHILD_NODE_ID}", in.CHILD_NODE_ID,"A");
let integer(4) is_valid_unique_parent = (parent_count<=1);
let integer(4) is_valid_effdt = is_defined(in.EFFDT) && (string_trim(in.EFFDT)!="");
let integer(4) is_valid_eff_status = is_defined(in.EFF_STATUS) && (string_trim(in.EFF_STATUS)!="");
if ( is_valid_parentnode_in_man_seg && is_valid_childnode_in_man_seg && is_valid_unique_parent && !(is_null(is_valid_effdt) || !is_valid_effdt) && (!(is_null(is_valid_eff_status) || !is_valid_eff_status) || ( is_defined(in.EFF_STATUS) && (string_trim(in.EFF_STATUS)!="I"))) )
begin
valdn_rslt ="Valid";
end
