The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.

Filter Example with upper and lower case

PrenticePrentice Member Posts: 66 Maven
edited December 2019 in Help
Hi again,

After just asked this question and accepted it, but I've ran into yet another problem. Yes, the solution works, but when I try to apply it to my real data it fails and I can't seem to figure out why. So this is what I exactly have:

Read Excel -> Extract Macro.
This reads an Excel file where I then have a macro (CustomerName) that stores the customer name from the excel file which will be used in the filter. 

I have another path that goes like this:
Read Excel -> Filter Examples -> Res
I have it read a different sheet in the Excel file and then a filter for the customer name applied for the customer attribute. This filter reads as follows:  "matches(Customer,".+"+%{CustomerName}+".+") and this filters it correctly, except the few cases where the customer is capitalised. 
I've tried the following which I saw in another thread:  "matches(lower(Customer),".+"+%{CustomerName}+".+") this filters everything out and leaves only the attributes. 

So the answer that @mschmitz gave me in my previous question does work, however it leaves out the few cases where the customer is capitalised

Thanks again!
I'm sorry for the amount of (simple) questions I ask, but I'm just not fully familiarised with the software


Best Answer


  • Options
    PrenticePrentice Member Posts: 66 Maven
    This actually worked, you're right. The macro needed to be lower case. Thanks!
Sign In or Register to comment.