How can we help you today? How can we help you today?

same table mutliple columns wont match

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
ID Name Name2 Helper Helper2 ID Name Name2 Helper Helper2
1 Dave Dave Dave Dave --> 1 Lucas Lucas Lucas Lucas
2 Dave Dave Rachel Mira --> 2 Lucas Lucas Rune Gerald
3 Jan Jan Louise Louise --> 3 Patrick Patrick Marie Marie
4 Jan Jan Jan Jan --> 4 Patrick Patrick Patrick Patrick
5 Rachel Mira Louise Dave --> 5 Rune Gerald Marie Lucas
6 Mira Rachel Mira Rachel --> 6 Gerald Rune Gerald Rune
manmetbaardt
0

Comments

1 comment

Sort by
  • Eddie D
    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 D
    0

Add comment

Please sign in to leave a comment.