Replacing numeric values (Map) in Turbo Prep

Tripartio
Tripartio New Altair Community Member
edited November 5 in Community Q&A
It seems that Turbo Prep does not have the option to replace numeric values (e.g. replace all occurances of 555 with 5); it seems that replace only works with nominal values. This might have something to do with the oddity that the Replace operator in RM only works on nominal values, whereas Map is the appropriate operator for numeric values. But how then can I replace values using Turbo Prep?
Tagged:

Best Answer

  • varunm1
    varunm1 New Altair Community Member
    Answer ✓
    @Tripartio

    Good Question. Yes, I didn't see an option for mapping in Turboprep and replace doesn't work on numerical data as mentioned in your post. To replace in turbo prep I changed the type of attribute using "change type" option in transform to Category. Then I replaced the values as needed and then again changed the attribute type back to numerical.

    @IngoRM can suggest more on this.

    Thanks

Answers

  • varunm1
    varunm1 New Altair Community Member
    Answer ✓
    @Tripartio

    Good Question. Yes, I didn't see an option for mapping in Turboprep and replace doesn't work on numerical data as mentioned in your post. To replace in turbo prep I changed the type of attribute using "change type" option in transform to Category. Then I replaced the values as needed and then again changed the attribute type back to numerical.

    @IngoRM can suggest more on this.

    Thanks
  • IngoRM
    IngoRM New Altair Community Member
    Hi,
    The way @varunm1 is describing this is the way to go for now.  I have added the idea of allowing to replace also for numerical values to the feature request list though.
    Best,
    Ingo

Categories