here in these two files we have ranges like upto to 21 , 22 to 28 like that so i asked a doubt in the community regarding how we can import this file into our rule group and perform the operations because the data is in ranges (22 to 28) . so in the community one sir said we need to create new excel file and split the data like this
and i have splited the data and created master data for it. And now i have a doubt like how we can take this values and perform the logic operations like in the decision table we wont able to use the input value in the logic section right it is only usable in the condition field so how can we perform the logic operations using these values ?
You can use a decision table for that since it doesn’t have a lot of data in it.
In the decision table you can check the ranges and assign the correct value to your output like loading_perc = 2.2 depending on the requirement.
like manually adding the value in the decision table in the logic section like (between 0 | 1 ) like this ?? i have done like that yesterday by manually updating but the value wont be added dynamically right thats why i asked the doubt here is that the proper way to do it
Hello @Aswin ,
When you upload the master data, you can use the filter option by selecting a column name. Then, apply a condition such as greater than or less than and provide the value as user input.
There is an output section just below, which serves as a mapping area. Here, you can map your target and link the corresponding age loading (extra cost based on age). This mapped value can then be used in the next rule.
The was an option that was provided by @Rocky with the screenshot aswell, Please see the like above. That is more scalable since it uses the masterdata.And as @Aswin is saying you can get the specific data from the uploaded masterdata by filtering where you can filter by column names.
yeah i know that thats why i didnt statically entered the value there but my doubt is that we get the data like driver age from and driver age to and age loading like this
Hello @Aswin , You can use a query with the AND operator, where the driver age is checked between the Driver Age From and Driver Age To columns. The driver age will be your input source, and in the output section you simply map the target as Age Loading.
