I have a scenario wherein, I have Rule_Set, ID_no, Sys_Key.
There is another Table (a Mapping Load) which has Certain Rule_Set and Sys_Key Defined. like;
The requirement is , the ID_no should be fetched , for the Rules mentioned in the Mapping Load Table for the Sys_Key, If the rule is not mentioned, then all the Sys_Key should be fetched. thus the result should be;
The actual app has a complex data, hence Association is not the solution.
I was thinking of creating the Flag , but it somehow is feting the 'ID_no 3456' in this case for the condition where I am trying to get the rules not mentioned in the Mapping Table.
Appreciate any help!
(html, codepage is 1252, embedded labels, table is @1);
(html, codepage is 1252, embedded labels, table is @2);
(html, codepage is 1252, embedded labels, table is @1)
where not Exists(Rule_Set);
LOAD * Resident Data;
DROP Table Data;
load * Inline
mapping LOAD * Inline
LOAD Rule_Set,ID_no,Sys_Key,if(ApplyMap('Map1',Rule_Set,'NA')='NA',1,if(ApplyMap('Map1',Rule_Set)=Sys_Key,1,0)) as IsMapAvailable
Resident Data1 where IsMapAvailable=1;
drop Table Data;
drop Table Data1;
Thanks for the solution option.
I have tried using the ApplyMap technique this way, It creates a flag for the Mentioned rules, but while taking up the Rule not mentioned (in this scenario Rule 3 - ID -4567), it takes up the remaining Rule as well ( here,
Rule 1- ID 2345 ) !
Appreciate any further help.