same table mutliple columns wont match

manmetbaardt · May 30, 2024 1:35PM

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

Eddie D · June 6, 2024 8:04AM

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

same table mutliple columns wont match

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk