Use SSN dataset on numeric column

Hello,

I want to use the SSN dataset on a column defined as number(19,0) but I can't select the SSN dataset.
When the column is defined as a nvarchar, I can select the SSN dataset.
Creating my own dataset did not solve the problem/

Is there any way out if this, except for changing the type of my column?

Success,
Kees
Tagged:

Best Answer

  • dOCTOClonedOCTOClone Posts: 82 Silver 5
    Accepted Answer
    Hi @kees thank you for your post.

    There may be an easier way of achieving this using a Row-Internal Sync rule rather than using a substitution rule, given that we can build some SQL directly into this particular type of rule.
    What you will need to do here is target the column you're trying to mask (I guess the SSN column) and then select the SSN DataSet as a parameter. Then we just have to cast it to a numeric value like in the attached picture.

    Let me know if this helps - thank you very much!



Answers

Sign In or Register to comment.