Re: I want to group different item by their brand

demonlovesongdemonlovesong Member Posts: 16 Contributor I
edited December 2018 in Help

Hi , i had created a dictionary for all the brand name? how can i combine the two table together? thank you very much

Tagged:

Answers

  • rfuentealbarfuentealba Moderator, RapidMiner Certified Analyst, Member, University Professor Posts: 396   Unicorn
    Hi, @demonlovesong

    Perform a *Generate ID* on your brand table, then *Join* with full join, then use *Filter Examples* with a condition where the product name /begins with/ the brand name. Saving the result is easy from there.

    That would be the easiest path given your data. Great job!
    sgenzer
  • rfuentealbarfuentealba Moderator, RapidMiner Certified Analyst, Member, University Professor Posts: 396   Unicorn
    BTW, this is a new question and I moved it to its own thread. Make sure you keep question threads small so that people don't get lost.
    sgenzer
  • demonlovesongdemonlovesong Member Posts: 16 Contributor I

    Hi, when i performing the outer(full) join, it and i use the SKU description and Brand name as the foreign key, it seems the join operation is not working

  • rfuentealbarfuentealba Moderator, RapidMiner Certified Analyst, Member, University Professor Posts: 396   Unicorn
    Hey,

    Do you mind to share your XML process?

    All the best,

    Rodrigo.
Sign In or Register to comment.