Options

How to filter the unnecessary attributes from JSON TO DATA output

Somnath_DasSomnath_Das Member Posts: 31 Maven
From the output of the JSON TO DATA operator I want to select only specific attributes out of all. Without using SELECT ATTRIBUTE is there any other way? Please suggest me a way. 
Tagged:

Best Answers

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,510 RM Data Scientist
    Solution Accepted
    You can use 'regular expression' in Select Attributes to define a rule what to be selected
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    ceaperezceaperez Member Posts: 522 Unicorn
    Solution Accepted
    Hi @Somnath_Das
    I don't know what's wrong with Select Attributes Operator, in this case is the right choice. The Work on Subset Operator,  let  you to choose a subset of Attributes, similar to Select Attributes Operator.
    Work on Subset - RapidMiner Documentation

    Best

Answers

  • Options
    ceaperezceaperez Member Posts: 522 Unicorn
    edited April 2021
    Hi @Somnath_Das
    you can also work with  Work on Subset Operator.

    Best
  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,510 RM Data Scientist
    Whats wrong with Select Attributes?
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    Somnath_DasSomnath_Das Member Posts: 31 Maven
    Instead of manually selecting the attribute is there a way to automate the selection based on a criteria like null etc
  • Options
    Somnath_DasSomnath_Das Member Posts: 31 Maven
    @ceaperez can u please elaborate your comment.
Sign In or Register to comment.