Comparing 2 datasets

IIShriyaIIIIShriyaII Member Posts: 3 Newbie
How do I compare 2 data sets and display whats different. The tables have the same data but differ in column Names. I have attached my process below.

Please help.

Answers

  • varunm1varunm1 Moderator, Member Posts: 1,207 Unicorn
    Hello,

    If you are looking to compare two datasets, please see attached thread where it was discussed.

    https://community.rapidminer.com/discussion/31292/comparing-two-sets-of-data

    Thanks
    Regards,
    Varun
    https://www.varunmandalapu.com/

    Be Safe. Follow precautions and Maintain Social Distancing

  • IIShriyaIIIIShriyaII Member Posts: 3 Newbie
    Hi,

    I looked at that, but since the two tables have columns that are named differently it doesn't work.
  • varunm1varunm1 Moderator, Member Posts: 1,207 Unicorn
    edited April 2019
    Oh ok, are those columns same but just had different names? If there are fewer columns and you want to do it quick you can rename using rename operator just for this process.
    Regards,
    Varun
    https://www.varunmandalapu.com/

    Be Safe. Follow precautions and Maintain Social Distancing

  • IIShriyaIIIIShriyaII Member Posts: 3 Newbie
    Yes they are the same columns just named differently.
  • Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn
    If your columns are really the same (same data type, same order) but just have different names, you can easily use Rename by Generic Names operator on both datasets and then proceed.
    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
Sign In or Register to comment.