The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Comparing 2 datasets

IIShriyaIIIIShriyaII Member Posts: 3 Learner I
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 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 Learner I
    Hi,

    I looked at that, but since the two tables have columns that are named differently it doesn't work.
  • varunm1varunm1 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 Learner I
    Yes they are the same columns just named differently.
  • Telcontar120Telcontar120 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.