same table mutliple columns wont match

manmetbaardtmanmetbaardt Posts: 1 New member
edited June 4, 2024 1:25PM in Data Masker for SQL Server
i'm trying to get it so that i get something like this. they are all in the same table how would i go about doing this
IDNameName2HelperHelper2IDNameName2HelperHelper2
1DaveDaveDaveDave-->1LucasLucasLucasLucas
2DaveDaveRachelMira-->2LucasLucasRuneGerald
3JanJanLouiseLouise-->3PatrickPatrickMarieMarie
4JanJanJanJan-->4PatrickPatrickPatrickPatrick
5RachelMiraLouiseDave-->5RuneGeraldMarieLucas
6MiraRachelMiraRachel-->6GeraldRuneGeraldRune

Answers

  • Eddie DEddie D Posts: 1,800 Rose Gold 5
    Hi, thank you for your forum post.
    I believe that you also submitted a support ticket to us at Redgate.

    I am little confused by your message.
     
    I suspect you need to be using a Substitution Rule and select the Data Set that may have many values so that the same names do not keep appearing.
    Do the following help documents on getting started and substitution rules help you?

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.