Comparing 2 datasets

IIShriyaII
IIShriyaII New Altair Community Member
edited November 5 in Community Q&A
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

  • varunm1
    varunm1 New Altair Community Member
    Hello,

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

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

    Thanks
  • IIShriyaII
    IIShriyaII New Altair Community Member
    Hi,

    I looked at that, but since the two tables have columns that are named differently it doesn't work.
  • varunm1
    varunm1 New Altair Community Member
    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.
  • IIShriyaII
    IIShriyaII New Altair Community Member
    Yes they are the same columns just named differently.
  • Telcontar120
    Telcontar120 New Altair Community Member
    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.