Hi Stephen,
Thanks a lot for your quick reply. That really helps.
I went through the decision tables and at first thought that it exactly fits for my scenario, but further analyzing, i could see some complications, as follows,
1. My criteria file, has a criteria column, which contains a query string like, (A=(1,2,3) and B=(20) and C=(1:9,30:39,56)), where A, B and C are different fields.
2. Each row has a different query string, with different set of fields and values. for eg, a row with (A=something and B=something and D=something) or (D=something and E=something and A=something) etc.,
3. The main complexity is, some query has "=" and some has "<>". for eg, (A<>(1,2,3) and B=(20) and C=(11:19,40:49,61))
So if i need to use a decision table, then i need to restructure my existing file, by parsing the query and splitting the fields into separate columns, but still after that, due to point 3 complexity, i think it will not be possible to use this decision table feature.
Regards,
Ananth Raman.