Re: I want to group different item by their brand

demonlovesongdemonlovesong MemberPosts:16Contributor I
edited December 2018 inHelp

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 ProfessorPosts:568Unicorn
    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 ProfessorPosts:568Unicorn
    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 MemberPosts:16Contributor 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 ProfessorPosts:568Unicorn
    Hey,

    你介意分享你的XML过程?

    All the best,

    Rodrigo.
Sign InorRegisterto comment.