Options

Loss of Attributes in RM Drop Down

SkyTraderSkyTrader Member Posts: 88 Contributor II
edited September 2020 in Help
Hi there,

I've raised this question before in other threads relating to other topics/processes but not had a solution that has permanently resolved it and would like to add it here as it's own topic.

When I first started using RM a few months ago the attribute drop down alway showed me what was in my Dow Jones, FTSE, or £/$ Excel data files. By that i mean if I wanted to select an attribute from my file in RM there would be a long list of attributes like open, high, low, close, EMA, RSI, etc, that I could select.

This functionality is now no longer available. I have done two updates since I first used RM. All I get, using any of my processes, when trying to retrieve a data set, is blank drop downs empty of any Excel attributes. I have tried a myriad of "solutions" including re-importing the data files, deleting Retrieve and Read Excel operators from processes, deleting Excel files from RM and reimporting all to no avail.

Even writing in "close" still makes not difference? I can say with 100% certainly that close exists in my file and is written exactly as "close" (and without any special characters attached to the word as occurred with one Yahoo Finance FTSE download, that attached an asterisk to the close, i.e. it read as: close* in my Excel file, therefore meaning RM could not recognise the attribute "close" from my typed in "close" suggestion.

Here's a screenshot of one of many I've got:



Can someone please give me a permanent solution so I can get back to using RM in the manner it was designed and which I first encountered it?

Many thanks!

Answers

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,517 RM Data Scientist
    edited September 2020
    Hi,
    You have a very clear error message. The column does not exist in your data. It is that simple. This is not at all a bug or something. If you do not post data and processes is it impossible to diagnose what you did wrong.

    ~Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    SkyTraderSkyTrader Member Posts: 88 Contributor II
    Hi Martin, @mschmitz

    Happy to post processes etc, but just for now, this is what I just did:

    1) Delete Excel file in repository.

    2) Import Data:


    3) Close appears in Example Set:


    4) Set Close to Label:


    5) Click on Next -- and complete import:


    6) Go to Retrieve and select new import file:
    This is where it's going wrong. The Close doesn't exist?


    7) Windowing operator has blank attributes despite screenshot above showing they exist (albeit without the Close!):



    8) Enter the word "Close" :



    I'm pretty certain the attribute exists so what can I do?

    Many thanks,
  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,517 RM Data Scientist
    the error message is explicitly telling you what your error is. Close is a special attribute (label) you need to check "include special attributes"as aparameter.
    Also note, that you used "close" not "Close" for horizon attribute.

    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    SkyTraderSkyTrader Member Posts: 88 Contributor II
    Cheers Martin, @mschmitz
    "Include special attributes" fixed half the problem. How do I get the attributes drop down menus to self populate with attributes (that are in my Excel files) and avoid warning like this:



    This process above was derived from a YouTube video on Rm that doesn't use Set Role:




    Thanks again,
    Best,
    SkyTrader
  • Options
    MarcoBarradasMarcoBarradas Administrator, Employee, RapidMiner Certified Analyst, Member Posts: 272 Unicorn
    @SkyTrader the only way of not obtaining that error with the process you show is by setting the role of your attribute as label while importig the data to RM. The other way of doing that is by setting the Role with the Set Role operator and picking th attribute which you want your model to predict since its needed for the models to learn a solution.

    Best Regards 
  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,517 RM Data Scientist
    can you please check if "Validate Automatically" is checkmarked?
    Best,
    Martin

    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.