we have a requirement to fetch some values through excel Upload.
example :
In excel we retrieve below data
Column 1
Column 2
SCRS1E31
ABC
D5
XYZ
Based on column 1 we need to set some other fields, column 1 contains a code and based on that code we need to set some values.
Column 1
type
start date
end date
Number
SCRS1E31
Screening
1
31
D5
Day
5
we have used regular expressions to find this pattern, then used below decision table to find retrun values. but the issue when we test the regular expression, its working find based on the input. but when we use it as expression in a decision table. every time it returning some other value.
Not sure if the reg expression is not working or the column is not appropriately set OR parameter is not being passed. I would suggest you have a similar implementation as below
Set a boolean flag (Let’s say “TrueFlag”) to true on the page where the decision table is executed.
Create two when rules one for screening and another for Day
Cal the when rule in the row as shown in the image.
Thanks for the response. what we have missed is to set the Boolean flag when execute decision table. when we do that, our previous approach too working fine.
