Is there a way to have a decision table behave with a vloopup? Basically we have a metadata column which the user can select from a drop down. This then drives the values of the action columns. This works except that instead of the value of the vlookup I see the actual vlookup text(i.e something like VLOOKUP(F11)). Is this possible? -- View this message in context: http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082.html Sent from the Drools: User forum mailing list archive at Nabble.com. _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users

They are different sheets. Basically we have a our tables on sheet 1 and sheet 2 is populated from an import of data from an external datasource to allow a vlookup of information(so the business user can see the data/and we can maintain it) manstis wrote > Is the VLOOKUP in the same sheet? > > I think there are problems with Apache POI resolving formulas across > different worksheets (but am guessing based on some other changes we had > to > make regarding linked workbooks). > > > On 17 June 2014 16:36, gboro54 < > gboro54@ > > wrote: > >> Is there a way to have a decision table behave with a vloopup? Basically >> we >> have a metadata column which the user can select from a drop down. This >> then >> drives the values of the action columns. This works except that instead >> of >> the value of the vlookup I see the actual vlookup text(i.e something like >> VLOOKUP(F11)). >> >> Is this possible? >> >> >> >> -- >> View this message in context: >> http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082.html >> Sent from the Drools: User forum mailing list archive at Nabble.com. >> _______________________________________________ >> rules-users mailing list >> > rules-users@.jboss >> https://lists.jboss.org/mailman/listinfo/rules-users >> > > _______________________________________________ > rules-users mailing list > rules-users@.jboss > https://lists.jboss.org/mailman/listinfo/rules-users -- View this message in context: http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082p40... Sent from the Drools: User forum mailing list archive at Nabble.com. _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users

I will work on a test case and create a defect for it. I will see if I can't get some time to take a look at this myself but will keep you informed about my status on completing this ticket manstis wrote > That then is indeed a bug. > > Can you please raise a DROOLS JIRA and attach a unit test demonstrating > the > problem (preferably please submit your unit test as a Pull Request)? > > We're always on the look out for community contributions, so if you want > to > tackle a fix it would be appreciated; otherwise we'll add the JIRA to the > list to look at some time. > > With kind regards, > > Mike > > > > > On 17 June 2014 17:25, gboro54 < > gboro54@ > > wrote: > >> They are different sheets. Basically we have a our tables on sheet 1 and >> sheet 2 is populated from an import of data from an external datasource >> to >> allow a vlookup of information(so the business user can see the data/and >> we >> can maintain it) >> >> >> manstis wrote >> > Is the VLOOKUP in the same sheet? >> > >> > I think there are problems with Apache POI resolving formulas across >> > different worksheets (but am guessing based on some other changes we >> had >> > to >> > make regarding linked workbooks). >> > >> > >> > On 17 June 2014 16:36, gboro54 < >> >> > gboro54@ >> >> > > wrote: >> > >> >> Is there a way to have a decision table behave with a vloopup? >> Basically >> >> we >> >> have a metadata column which the user can select from a drop down. >> This >> >> then >> >> drives the values of the action columns. This works except that >> instead >> >> of >> >> the value of the vlookup I see the actual vlookup text(i.e something >> like >> >> VLOOKUP(F11)). >> >> >> >> Is this possible? >> >> >> >> >> >> >> >> -- >> >> View this message in context: >> >> >> http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082.html >> >> Sent from the Drools: User forum mailing list archive at Nabble.com. >> >> _______________________________________________ >> >> rules-users mailing list >> >> >> >> > rules-users@.jboss >> >> >> https://lists.jboss.org/mailman/listinfo/rules-users >> >> >> > >> > _______________________________________________ >> > rules-users mailing list >> >> > rules-users@.jboss >> >> > https://lists.jboss.org/mailman/listinfo/rules-users >> >> >> >> >> >> -- >> View this message in context: >> http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082p40... >> Sent from the Drools: User forum mailing list archive at Nabble.com. >> _______________________________________________ >> rules-users mailing list >> > rules-users@.jboss >> https://lists.jboss.org/mailman/listinfo/rules-users >> > > _______________________________________________ > rules-users mailing list > rules-users@.jboss > https://lists.jboss.org/mailman/listinfo/rules-users -- View this message in context: http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082p40... Sent from the Drools: User forum mailing list archive at Nabble.com. _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users

Re: [rules-users] 5.6 Decision Table VLookup. Can you tell me the status on this item please? I need to use a vlookup as well. -- View this message in context: http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082p40... Sent from the Drools: User forum mailing list archive at Nabble.com. _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users

Hi Michael, Just a few questions: 1. Does it work in later versions of DROOLS? Which one? 2. If I put the lookups on the same sheet, will it work? Is it only because the lookups are on a separate sheet? Thanks, Jan Sent from my iPhone On Jul 15, 2014, at 7:53 AM, Michael Anstis <michael.anstis(a)gmail.com&gt; wrote: No progress. Community contributions always appreciated. http://docs.jboss.org/drools/release/6.0.1.Final/drools-docs/html/Welcome... On 15 July 2014 12:38, J Rose <ufos(a)comcast.net&gt; wrote: > Re: [rules-users] 5.6 Decision Table VLookup. Can you tell me the > status on > this item please? I need to use a vlookup as well. > > > > -- > View this message in context: > http://drools.46999.n3.nabble.com/5-6-Decision-Table-VLookup-tp4030082p40... > Sent from the Drools: User forum mailing list archive at Nabble.com. > _______________________________________________ > rules-users mailing list > rules-users(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/rules-users > _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users