Map string IDs to Integer values in multiple datasets

SadeemRM
SadeemRM New Altair Community Member
edited November 2024 in Community Q&A
I have two datasets contains ID column , I want to map the string IDs to integer values and keep the same mapping for the different datasets to join them later after processing : 

IDs Example : 

ae264e3637204a6fb9bb56bc8210ddfd
4d5c57ea9a6940dd891ad53e9dbe8da0
3f207df678b143eea3cee63160fa8bed
9b98b8c7a33c4b65b9aebfe6a799e6d9
0b1e1539f2cc45b7b9fa7c272da2e1d7
2298d6c36e964ae4a3e7e9706d1fb8c2
fafdcd668e3743c1bb461111dcafc2a4
5a8bc65990b245e5a138643cd4eb9837
f19421c1d4aa40978ebb69ca19b0e20d
2906b810c7d4411798c6938adc9daaa5
Tagged:

Best Answer

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓
    Hi,
    i would recommend to have a look at nominal to numerical with the option "Unique integer".

    BR,
    Martin

Answers

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓
    Hi,
    i would recommend to have a look at nominal to numerical with the option "Unique integer".

    BR,
    Martin
  • SadeemRM
    SadeemRM New Altair Community Member
    Thank you, it is working fine