Options

Hi, i want to know if indexing line and column is possible

nic__onic__o Member Posts: 7 Newbie
Hi, i want to know if  indexing line and column is possible, i want to peak one specific cell of an Excel tab, like [i][j], i tried a lot of operator wihout sucess...

I will really appreciate your answers, 
Thank you :)

Best Answer

Answers

  • Options
    lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, Member Posts: 1,195 Unicorn
    Hi @nic__o ,

    You can use Extract Macro operator with  : 
     - macro type = data_value (the you choose the example index and the attribute name)

    Regards,

    Lionel
  • Options
    nic__onic__o Member Posts: 7 Newbie
    Thank's you Lionel its working, but is there a dynamic way to do it ? I mean, for example if I want to pick the last element of a column for any files in entry, is this could be possible ?
    Best regards,
  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,509 RM Data Scientist
    Hi,
    i think you can btw use -1  as example index to get the last item.
    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, Member Posts: 1,195 Unicorn
    Hi @mschmitz,

    I must admit that it is a more elegant solution...
    I'm a too complicated boy... :)

    Regards,

    Lionel

Sign In or Register to comment.